utl_file

[fortune]

I am trying to read a comma delimited file and load into two tables using utl_file package.
some columns of the file go into one and some into the other.the error that i get is the value error and the second is ORA-06502: PL/SQL: numeric or value error;

any help would be muich appreciated.
how do i go about writing a stored procedure.maybe i am doing it the wrong way.
is there any example that i can take a look at.

 

[scotty7998]

The error that you are getting is caused by attempting to insert a character into a number field. You need to make sure your mapping your positions in your file to the right datatype. This should take care of it.

Kevin M. Watford
kwatford@ddyne.com