ORA-03113 :: does Oracle support selecting a blob column into scrollable cursor?

Home -> Community -> Usenet -> c.d.o.server -> ORA-03113 :: does Oracle support selecting a blob column into scrollable cursor?

From: CMa <mcwiklinski_at_wp.pl>
Date: 5 Jan 2006 03:26:10 -0800
Message-ID: <1136460370.723070.33340@z14g2000cwz.googlegroups.com>

My application uses an OCI to access the Oracle 9.2.0.5 database. I want to execute a SELECT statement that selects a BLOB column into a scrollable cursor - OCIStmtExecute runs with mode set to OCI_STMT_SCROLLABLE_READONLY.
After that, the first call of OCIStmtFetch2 function returns ORA-03113 error.
When cursor is forward-only then everything works OK.

Why? Does Oracle support selecting a blob column into scrollable cursor at all? Received on Thu Jan 05 2006 - 05:26:10 CST