Hi,
I am trying ora2pg (11.1) to import data from Oracle 11x tables and ran into error for tables that have data in the LONG RAW type columns.
DBD::Oracle::db prepare failed: ORA-00997: illegal use of LONG datatype (DBD ERROR: error possibly near <> indicator at char 395 in 'SELECT "VERSION_SEQ_KEY","VERSION_NUMBER","DESCRIPTION","ISACTIVE","ICON","AUTHOR_NAME","AUTHOR_COMPANY","AUTHOR_EMAIL",to_char("CREATED_DATE", 'YYYY-MM-DD HH24:MI:SS'),"CREATED_BY",to_char("UPDATED_DATE", 'YYYY-MM-DD HH24:MI:SS'),"UPDATED_BY","MAX_NUMBER","MIN_NUMBER","PARENT_KEY","NAME","RELEASE_NOTES","DTS_SEQ_KEY","DDSVERSION_SEQ_KEY","TEARDOWN_TIME","SETUP_TIME",utl_raw.cast_to_varchar2(<>"DTSVO"),"SOURCE" FROM TABLE_FOO a') [for Statement "SELECT "VERSION_SEQ_KEY","VERSION_NUMBER","DESCRIPTION","ISACTIVE","ICON","AUTHOR_NAME","AUTHOR_COMPANY","AUTHOR_EMAIL",to_char("CREATED_DATE", 'YYYY-MM-DD HH24:MI:SS'),"CREATED_BY",to_char("UPDATED_DATE", 'YYYY-MM-DD HH24:MI:SS'),"UPDATED_BY","MAX_NUMBER","MIN_NUMBER","PARENT_KEY","NAME","RELEASE_NOTES","DTS_SEQ_KEY","DDSVERSION_SEQ_KEY","TEARDOWN_TIME","SETUP_TIME",utl_raw.cast_to_varchar2("DTSVO"),"SOURCE" FROM TABLE_FOO a"] at /usr/local/share/perl5/Ora2Pg.pm line 5983.
FATAL: ORA-00997: illegal use of LONG datatype (DBD ERROR: error possibly near <> indicator at char 395 in 'SELECT "VERSION_SEQ_KEY","VERSION_NUMBER","DESCRIPTION","ISACTIVE","ICON","AUTHOR_NAME","AUTHOR_COMPANY","AUTHOR_EMAIL",to_char("CREATED_DATE", 'YYYY-MM-DD HH24:MI:SS'),"CREATED_BY",to_char("UPDATED_DATE", 'YYYY-MM-DD HH24:MI:SS'),"UPDATED_BY","MAX_NUMBER","MIN_NUMBER","PARENT_KEY","NAME","RELEASE_NOTES","DTS_SEQ_KEY","DDSVERSION_SEQ_KEY","TEARDOWN_TIME","SETUP_TIME",utl_raw.cast_to_varchar2(<>"DTSVO"),"SOURCE" FROM TABLE_FOO a')
Aborting export...
On 10.1, the import works. However, I saw that there was some bug related to this type that was fixed in 11.1 and therefore I was trying it again with 11.1.