ORA-01465 using sys_guid() with SQL*Loader
217816Aug 17 2007 — edited Aug 23 2007Hi All -
Trying to load an audio file into a table using SQL*Loader. My audio_id column is populated with a default sys_guid() value geerated during the insert (value not known ahead of time).
the load is failing with the following error:
Record 1: Rejected - Error on table AUDIO, column AUDIO_ID.
ORA-01465: invalid hex number
Here's the control file:
LOAD DATA
INFILE *
INTO TABLE audio
APPEND
FIELDS TERMINATED BY ','
(audio_ID,
audio column object
(source column object
(localdata_fname FILLER CHAR(128),
localdata LOBFILE (audio.source.localdata_fname)
)
), upload_date_time
)
BEGINDATA
(sys_guid(),C:\users\Shakira.mp3,Shakira - 03 - (Featuring Wyclef Jean) Hips Don't Lie.mp3, sysdate),
If anyone has an idea how to circumnavigate this error, or has already expereinced it, I'd be grateful for any help.
Thanks You