Calling Stored procedure functions in SqlLoader [message #69155] |
Fri, 09 November 2001 07:01 |
Raphi
Messages: 3 Registered: November 2001
|
Junior Member |
|
|
I am loading data into a table from a flat file.
I need to change the way my control file works and add logic to it so that depending on the values of certain fields (positions) different positions may be inserted into the specified column.
Is this at all possible?
And am I allowed to call my own stored procedures from within the control file?
I.E.
decode(MyFunction(position[[1:4]],
'A', position[[1:4]],
position[[5:8]])
----------------------------------------------------------------------
|
|
|
|
|