I am new user of Oracle DBI. I can read non LOB data ok, but can not read LOB data. I get the error:
DBD::Oracle::db prepare failed: ORA-03115: unsupported network datatype or representation (DBD: odescr failed) I am simply trying to do a SELECT DOCID, B_FILE FROM BLOB_FILES WHERE DOCID='83' Where B_FILE is of the Oracle BLOB type. I am picking up a DBD::Oracle.pm file that was built on NT by my Oracle DBA. But after I installed this file on UNIX, I got this error: install_driver(Oracle) failed: DBD::Oracle object version 0.59 does not match bootstrap parameter 1.06 at /binlib/local/perl/perl5.005/lib/5.00502/sun5-solaris/DynaLoader.pm line 187. I then changed the line $DBD::Oracle::VERSION = '1.06'; in Oracle.pm to $DBD::Oracle::VERSION = '0.59'; This fixed the error, but as I said, I can not get past the 'unsupported network datatype or representation' error. Any feedback on what I am doing wrong is appreciated. I am very unclear about the need to 'compile' the DBD::Oracle module s/w. I also have no clue if the build of this s/w on NT can be used on UNIX. TIA, ----------------- Harry Duin (pronounced as hari [as in Hari Krishna] dine [as in eat out]) [EMAIL PROTECTED] tel:(312) 974-6379 pgr:(630) 362-9981 GMI IL1-231-18-32 Bank of America 231 S. LaSalle Street Chicago IL 60604
