| Error in calling stored function from sqlloader with filler columns [message #71157] |
Tue, 17 September 2002 04:09  |
Shalini singh
Messages: 11
Registered: September 2002
|
Junior Member |
|
|
we are trying to execute a stored functions with some arguments of which value is present in text file but that columns are not present in the database . so we are using fillers.
we are facing problem in passing columns with filler attribute in stored function.
how can we pass the filler values as an argument of the stored function
example of control file
load data
into table abc
feilds terminated by '~'
( acol filler char(10),
bcol "seq_ret(:acol)"
)
where seq_ret is the stored function and a col is the temp column so we had use filler since this value is to be used in this stored function.
Any help or pointer is greatly appreciated.
Regards,
Shalini
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
