Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am connecting to an oracle DB using the OLE DB connect option.
In my preceding load and select statements I am trying to read in a CLOB type. i am getting an unknow type error. Any suggestions?
LOAD PROJECT As Project,
DESCRIPTION as Description //(TYPE CLOB)
SQL SELECT
DESCRIPTION,
FROM .....
PLEASE HELP.
AFAIK you have to use ODBC when reading LOBs from Oracle, not OLEDB (at least I didn't succeed with OLEDB).
Rgds,
Joachim