2
Hi
We are uploading a picture image(jpg) as a BLOB in a table using
SQL Loader. We are parallely uploading the images at the same time from 2 different sessions on the server.
The command for uploading is as follows
SQLLDR username/password@DATABASE control=controlfile.ctl log=logfile.log DIRECT=TRUE
But on uploading the files simultaneously, we are getting the following error on one of the sessions.
>ORA-00604: error occurred at recursive SQL level 1
>ORA-00054: resource busy and acquire with NOWAIT specified
To resolve this issue we have added the option of PARALLEL = TRUE to the command. But we are getting the error
SQL*Loader-971: parallel load option not allowed when loading lob columns
Thus the combination of DIRECT=TRUE & PARALLEL=TRUE along with LOB datatypes is not giving us the desired result with SQL Loader .
Can you please help us resolve this issue.
Thanks in advance.
