| sqlloader [message #36379] |
Thu, 22 November 2001 08:05  |
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  |
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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
