Home » SQL & PL/SQL » SQL & PL/SQL » sqlloader
sqlloader [message #36379] Thu, 22 November 2001 08:05 Go to next message
renjith
Messages: 5
Registered: November 2001
Junior Member
Hello All,

Is it possible to call procedure from sqlloader. If it is possible, Please give me an example.

Thanks in Advance,
Renjith

----------------------------------------------------------------------
Re: sqlloader [message #36386 is a reply to message #36379] Fri, 23 November 2001 08:21 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
you can't call procedure from sqlloader , but calling function (which returns only one value) is possible.

look at following example:

LOAD DATA
INFILE 'ss.TXT'
APPEND
INTO TABLE fgh
(s1 position(01:05) "validate(:s1)")

validate is user defined function and takes one parameter and returns one value. function should return only one value . you can pass more than one parameter to that function.

----------------------------------------------------------------------
Previous Topic: Using COPY in a LOOP
Next Topic: How to insert a String type parameter while it should be Integer?
Goto Forum:
  


Current Time: Fri Mar 29 06:13:15 CDT 2024