OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS OCIEnvNlsEnvCreate(1db0a00,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS OCIHandleAlloc(5a30080,1db0a08,OCI_HTYPE_ERROR,0,0)=SUCCESS OCIAttrGet(5a30080,OCI_HTYPE_ENV,2bbc5e0,0,31,5a66330)=SUCCESS OCIAttrGet(5a30080,OCI_HTYPE_ENV,2bbc5e4,0,262,5a66330)=SUCCESS charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII (csid: utf8=871 al32utf8=873) OCIHandleAlloc(5a30080,1db0a10,OCI_HTYPE_SERVER,0,0)=SUCCESS OCIHandleAlloc(5a30080,1db0a18,OCI_HTYPE_SVCCTX,0,0)=SUCCESS OCIServerAttach(5a66a60, 5a66330, "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=MYHOST)(PROTOCOL=tcp)(PORT=1526))(ADDRESS=(HOST=MYHOST)(PROTOCOL=tcp)(PORT=1521)))(CONNECT_DATA=(SID=MYSID)))", 178, mode=DEFAULT,0)=SUCCESS OCIAttrSet(5a661e0,OCI_HTYPE_SVCCTX, 5a66a60,0,Attr=OCI_ATTR_SERVER,5a66330)=SUCCESS OCIHandleAlloc(5a30080,1db0a20,OCI_HTYPE_SESSION,0,0)=SUCCESS OCIAttrSet(5bb3c00,OCI_HTYPE_SESSION, 2604fc8,4,Attr=OCI_ATTR_USERNAME,5a66330)=SUCCESS OCIAttrSet(5bb3c00,OCI_HTYPE_SESSION, 2604fcd,4,Attr=OCI_ATTR_PASSWORD,5a66330)=SUCCESS OCISessionBegin(5a661e0,5a66330,5bb3c00,1,mode=DEFAULT 0)=SUCCESS OCIAttrSet(5a661e0,OCI_HTYPE_SVCCTX, 5bb3c00,0,Attr=OCI_ATTR_SESSION,5a66330)=SUCCESS 1..12 OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a733d8,5a66330,' drop table dbd_ora__drop_me ',29,1,0)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql DROP ( auto_lob1, check_sql1) dbd_describe skipped for DROP dbd_st_execute DROP (out0, lob0)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(5a661e0,5a733d8,5a66330,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f084,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f080,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute DROP returned (SUCCESS, rpc0, fn8, out0) OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f0c0,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS dbd_st_destroy OCIHandleFree(5a733d8,OCI_HTYPE_STMT)=SUCCESS OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a72348,5a66330,' CREATE TABLE dbd_ora__drop_me ( id INTEGER NOT NULL, data BLOB ) ',77,1,0)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql CREATE ( auto_lob1, check_sql1) dbd_describe skipped for CREATE dbd_st_execute CREATE (out0, lob0)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(5a661e0,5a72348,5a66330,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f084,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f080,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute CREATE returned (SUCCESS, rpc0, fn1, out0) OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f0c0,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS dbd_st_destroy OCIHandleFree(5a72348,OCI_HTYPE_STMT)=SUCCESS OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a72348,5a66330,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (1, EMPTY_BLOB())',63,1,0)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob1, check_sql1) dbd_describe skipped for INSERT dbd_st_execute INSERT (out0, lob0)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(5a661e0,5a72348,5a66330,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f084,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f080,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f0c0,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS dbd_st_destroy OCIHandleFree(5a72348,OCI_HTYPE_STMT)=SUCCESS dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a72348,5a66330,'SELECT data FROM dbd_ora__drop_me WHERE id = :p1',48,1,0)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql SELECT ( auto_lob0, check_sql1) dbd_describe SELECT (EXPLICIT, lb 80)... OCIStmtExecute(5a661e0,5a72348,5a66330,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f14c,0,OCI_ATTR_PARAM_COUNT,5a66330)=SUCCESS OCIParamGet(5a72348,4,5a66330,51a138,1,OCI_HTYPE_STMT)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a168,0,OCI_ATTR_DATA_TYPE,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a16a,0,OCI_ATTR_DATA_SIZE,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a180,0,OCI_ATTR_CHAR_USED,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a182,0,OCI_ATTR_CHAR_SIZE,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a184,0,OCI_ATTR_CHARSET_ID,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a186,0,OCI_ATTR_CHARSET_FORM,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a16c,0,OCI_ATTR_PRECISION,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a16e,0,OCI_ATTR_SCALE,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a16f,0,OCI_ATTR_IS_NULL,5a66330)=SUCCESS OCIAttrGet(5a72020,OCI_DTYPE_PARAM,51a170,23f16c,OCI_ATTR_NAME,5a66330)=SUCCESS Describe col #1 type=113(SQLT_BLOB / long) OCIDescriptorAlloc(5a30080,51a148,OCI_DTYPE_LOB,0,0) Described col 1: dbtype 113(SQLT_BLOB / long), scale 0, prec 0, nullok 1, name DATA : dbsize 4000, char_used 0, char_size 0, csid 0, csform 0(0), disize 8 fbh 1: 'DATA' NULLable, otype 113->113, dbsize 4000/8, p0.s0 OCIAttrSet(5a72348,OCI_HTYPE_STMT, 23f060,4,Attr=OCI_ATTR_PREFETCH_MEMORY,5a66330)=SUCCESS OCIAttrSet(5a72348,OCI_HTYPE_STMT, 23f0c8,4,Attr=OCI_ATTR_PREFETCH_ROWS,5a66330)=SUCCESS cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=1, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=1, Multiple Row Fetch=Off OCIDefineByPos(5a72348,51a140,5a66330,1,51a148,0,113,26053e8,2605388,2605328,mode=DEFAULT,0)=SUCCESS dbd_describe'd 1 columns (row bytes: 4000 max, 4000 est avg, cache: 0) dbd_bind_ph(1): bind :p1 <== 1 (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0) dbd_rebind_ph_char() (1): bind :p1 <== 1 (size 1/16/0, ptype 5(VARCHAR), otype 1 ) dbd_rebind_ph_char() (2): bind :p1 <== 1 (size 1/16, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(5a72348,1d33ce0,5a66330,":p1",placeh_len=3,value_p=2605568,value_sz=16,dty=1,indp=1d33d00,alenp=0,rcodep=1d33cf8,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(5a720a0,5a66330,1d33ca8,2b81e40,1d33ca8,2b81cf0)=SUCCESS OCIAttrGet(5a720a0,OCI_HTYPE_BIND,1d33cc4,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p1 <== 1 (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0) OCIAttrSet(5a720a0,OCI_HTYPE_BIND, 23f494,0,Attr=31,5a66330)=SUCCESS dbd_st_execute SELECT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(5a661e0,5a72348,5a66330,0,0,0,0,mode=DEFAULT,0)=SUCCESS rs_array_init:imp_sth->rs_array_size=1, rs_array_idx=0, prefetch_rows=0, rs_array_status=SUCCESS OCIAttrGet(5a72348,OCI_HTYPE_STMT,23f5d0,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) dbd_st_fetch 1 fields... OCIStmtFetch(5a72348,5a66330,1,2,0)=SUCCESS dbd_st_fetched 1 fields with status of 0(SUCCESS) field #1 with rc=0(OK) 25c8978 (field=0): OCILobLocatorPtr=SCALAR(0x25c8a50) ok 1 - returned valid locator dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(5a30080,536450,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a71328,5a66330,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (666, :p1)',56,1,0)=SUCCESS OCIAttrGet(5a71328,OCI_HTYPE_STMT,536464,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob1, check_sql1) dbd_describe skipped for INSERT dbd_st_finish OCIStmtFetch(5a72348,5a66330,0,2,0)=SUCCESS dbd_st_destroy OCIHandleFree(5a72348,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(5a661e0,5a66330,5a63e58,23f010,2355296)=INVALID_HANDLE OCIDescriptorFree(5a63e58,OCI_DTYPE_LOB) dbd_bind_ph(1): bind :p1 <== ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...' (type 0 (DEFAULT (varchar)), attribs: HASH(0x25c8c30)) dbd_rebind_ph() (1): rebinding :p1 as ' !"#$...' (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 0) OCIDescriptorAlloc(5a30080,1d33dc8,OCI_DTYPE_LOB,0,0) OCIAttrSet(5a63e58,OCI_DTYPE_LOB, 23f3ac,0,Attr=OCI_ATTR_LOBEMPTY,5a66330)=SUCCESS bind :p1 as ftype 113 (SQLT_BLOB / long) OCIBindByName(5a71328,1d33dc0,5a66330,":p1",placeh_len=3,value_p=1d33dc8,value_sz=8,dty=113,indp=1d33de0,alenp=0,rcodep=1d33dd8,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(5a71078,OCI_HTYPE_BIND,1d33da4,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p1 <== ' !"#$...' (in, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) dbd_bind_ph(1): bind :p1 <== ' !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$%&'()*+,-./0123456789:;<=>?@ !"#$...' (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as ' !"#$...' (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 0) OCILobIsTemporary(5a30080,5a66330,5a63e58,23f220)=SUCCESS OCIAttrSet(5a63e58,OCI_DTYPE_LOB, 23f2cc,0,Attr=OCI_ATTR_LOBEMPTY,5a66330)=SUCCESS bind :p1 as ftype 113 (SQLT_BLOB / long) OCIBindByName(5a71328,1d33dc0,5a66330,":p1",placeh_len=3,value_p=1d33dc8,value_sz=8,dty=113,indp=1d33de0,alenp=0,rcodep=1d33dd8,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(5a71078,OCI_HTYPE_BIND,1d33da4,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p1 <== ' !"#$...' (in, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) dbd_st_execute INSERT (out0, lob1)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(5a661e0,5a71328,5a66330,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(5a71328,OCI_HTYPE_STMT,23f5d4,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS OCIAttrGet(5a71328,OCI_HTYPE_STMT,23f5d0,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) OCIHandleAlloc(5a30080,536458,OCI_HTYPE_DESCRIBE,0,0)=SUCCESS OCIDescribeAny(5a661e0,5a66330,2581ef8,16,1,1,7,5a70770)=ERROR OCIDescribeAny(5a661e0,5a66330,2581ef8,16,1,1,1,5a70770)=SUCCESS OCIAttrGet(5a70770,OCI_HTYPE_DESCRIBE,23f280,0,OCI_ATTR_PARAM,5a66330)=SUCCESS OCIAttrGet(5a70720,OCI_DTYPE_PARAM,23f264,0,OCI_ATTR_NUM_COLS,5a66330)=SUCCESS OCIAttrGet(5a70720,OCI_DTYPE_PARAM,23f2b8,0,OCI_ATTR_LIST_COLUMNS,5a66330)=SUCCESS lob refetch from table dbd_ora__drop_me, 2 columns: OCIParamGet(5a706d0,53,5a66330,23f288,1,OCI_DTYPE_PARAM)=SUCCESS OCIAttrGet(5a70680,OCI_DTYPE_PARAM,23f268,0,OCI_ATTR_OBJECT,5a66330)=SUCCESS OCIAttrGet(5a70680,OCI_DTYPE_PARAM,23f2c0,23f26c,OCI_ATTR_SQLCODE,5a66330)=SUCCESS lob refetch table col 1: 'ID' otype 2 OCIParamGet(5a706d0,53,5a66330,23f288,2,OCI_DTYPE_PARAM)=SUCCESS OCIAttrGet(5a70610,OCI_DTYPE_PARAM,23f268,0,OCI_ATTR_OBJECT,5a66330)=SUCCESS OCIAttrGet(5a70610,OCI_DTYPE_PARAM,23f2c0,23f26c,OCI_ATTR_SQLCODE,5a66330)=SUCCESS lob refetch table col 2: 'DATA' otype 113 OCIDescriptorFree(5a70610,OCI_DTYPE_PARAM) lob refetch :p1 param: otype 113, matched field 'DATA' by name (DATA "p1") OCIDescriptorAlloc(5a30080,51a148,OCI_DTYPE_LOB,0,0) lob refetch sql: select DATA "p1" from dbd_ora__drop_me where rowid = :rid for update OCIHandleAlloc(5a30080,24e1578,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a72380,5a66330,'select DATA "p1" from dbd_ora__drop_me where rowid = :rid for update',68,1,0)=SUCCESS OCIDescriptorAlloc(5a30080,24e1588,OCI_DTYPE_ROWID,0,0) OCIBindByName(5a72380,24e1580,5a66330,":rid",placeh_len=4,value_p=24e1588,value_sz=8,dty=104,indp=0,alenp=0,rcodep=0,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS lob refetch 1 for ':p1' param: ftype 113 setup OCIDefineByPos(5a72380,23f278,5a66330,1,51a148,-1,113,2605a78,0,2605ad8,mode=DEFAULT,0)=SUCCESS OCIHandleFree(5a70770,OCI_HTYPE_DESCRIBE)=SUCCESS OCIAttrGet(5a71328,OCI_HTYPE_STMT,5a64c08,0,OCI_ATTR_ROWID,5a66330)=SUCCESS OCIStmtExecute(5a661e0,5a72380,5a66330,1,0,0,0,mode=DEFAULT,0)=SUCCESS OCILobCharSetForm(5a30080,5a66330,5a63d68,0)=SUCCESS OCILobCharSetId(5a30080,5a66330,5a63d68,0)=SUCCESS calling OCILobWrite fbh->csid=1 fbh->csform=0 amtp=540672 OCILobWrite(5a661e0,5a66330,5a63d68,23f4f4,1,2732f28,540672,0,0,0,1,0)=SUCCESS lob refetch 1 for ':p1' param: ftype 113, len 540672: LobWrite SUCCESS OCITransCommit(5a661e0,5a66330,0)=SUCCESS ok 2 - inserted into BLOB successfully OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a733d8,5a66330,'select data from dbd_ora__drop_me where id = 666',48,1,0)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql SELECT ( auto_lob1, check_sql1) dbd_describe SELECT (EXPLICIT, lb 1000000)... OCIStmtExecute(5a661e0,5a733d8,5a66330,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23eb5c,0,OCI_ATTR_PARAM_COUNT,5a66330)=SUCCESS OCIParamGet(5a733d8,4,5a66330,51a208,1,OCI_HTYPE_STMT)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a238,0,OCI_ATTR_DATA_TYPE,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a23a,0,OCI_ATTR_DATA_SIZE,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a250,0,OCI_ATTR_CHAR_USED,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a252,0,OCI_ATTR_CHAR_SIZE,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a254,0,OCI_ATTR_CHARSET_ID,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a256,0,OCI_ATTR_CHARSET_FORM,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a23c,0,OCI_ATTR_PRECISION,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a23e,0,OCI_ATTR_SCALE,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a23f,0,OCI_ATTR_IS_NULL,5a66330)=SUCCESS OCIAttrGet(5c12dc8,OCI_DTYPE_PARAM,51a240,23eb7c,OCI_ATTR_NAME,5a66330)=SUCCESS Describe col #1 type=113(SQLT_BLOB / long) OCIDescriptorAlloc(5a30080,51a218,OCI_DTYPE_LOB,0,0) Described col 1: dbtype 113(SQLT_BLOB / long), scale 0, prec 0, nullok 1, name DATA : dbsize 4000, char_used 0, char_size 0, csid 0, csform 0(0), disize 8 fbh 1: 'DATA' NULLable, otype 113->113, dbsize 4000/8, p0.s0 OCIAttrSet(5a733d8,OCI_HTYPE_STMT, 23ea70,4,Attr=OCI_ATTR_PREFETCH_MEMORY,5a66330)=SUCCESS OCIAttrSet(5a733d8,OCI_HTYPE_STMT, 23ead8,4,Attr=OCI_ATTR_PREFETCH_ROWS,5a66330)=SUCCESS cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=1, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=1, Multiple Row Fetch=Off OCIDefineByPos(5a733d8,51a210,5a66330,1,51a218,0,113,2605bc8,2605bf8,2605c28,mode=DEFAULT,0)=SUCCESS dbd_describe'd 1 columns (row bytes: 4000 max, 4000 est avg, cache: 0) dbd_st_execute SELECT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(5a661e0,5a733d8,5a66330,0,0,0,0,mode=DEFAULT,0)=SUCCESS rs_array_init:imp_sth->rs_array_size=1, rs_array_idx=0, prefetch_rows=0, rs_array_status=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f5b0,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) dbd_st_fetch 1 fields... OCIStmtFetch(5a733d8,5a66330,1,2,0)=SUCCESS dbd_st_fetched 1 fields with status of 0(SUCCESS) field #1 with rc=0(OK) OCILobGetLength(5a661e0,5a66330,5a63ce8,23f0f8)=SUCCESS OCILobCharSetForm(5a30080,5a66330,5a63ce8,0)=SUCCESS OCILobRead(5a661e0,5a66330,5a63ce8,23f0f4,1,27b8b98,540672,0,0,0,0)=SUCCESS OCILobRead field 1 of 1 SUCCESS: csform 0 (0), LOBlen 540672(bytes), LongReadLen 1000000(bytes), BufLen 540672(bytes), Got 540672(bytes) OCILobIsTemporary(5a30080,5a66330,5a63ce8,23f050)=SUCCESS 25c8e40 (field=0): ' !"#$...' dbd_st_finish OCIStmtFetch(5a733d8,5a66330,0,2,0)=SUCCESS dbd_st_destroy OCIHandleFree(5a733d8,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(5a661e0,5a66330,5a63ce8,23f010,2355296)=INVALID_HANDLE OCIDescriptorFree(5a63ce8,OCI_DTYPE_LOB) ok 3 - got back what we put in dbd_preparse scanned 2 distinct placeholders OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a6f208,5a66330,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (:p1, EMPTY_BLOB()) RETURNING data INTO :p2',89,1,0)=SUCCESS OCIAttrGet(5a6f208,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob0, check_sql1) dbd_describe skipped for INSERT OCIHandleFree(5a70770,OCI_HTYPE_DESCRIBE)=INVALID_HANDLE dbd_st_destroy OCIHandleFree(5a71328,OCI_HTYPE_STMT)=SUCCESS OCIDescriptorFree(5a64c08,OCI_DTYPE_ROWID) OCIHandleFree(5a72380,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(5a661e0,5a66330,5a63d68,23efd0,2355232)=INVALID_HANDLE OCIDescriptorFree(5a63d68,OCI_DTYPE_LOB) OCILobIsTemporary(5a30080,5a66330,5a63e58,23f010)=SUCCESS OCIDescriptorFree(5a63e58,OCI_DTYPE_LOB) dbd_bind_ph(1): bind :p1 <== 2 (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0) dbd_rebind_ph_char() (1): bind :p1 <== 2 (size 1/16/0, ptype 5(VARCHAR), otype 1 ) dbd_rebind_ph_char() (2): bind :p1 <== 2 (size 1/16, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(5a6f208,1d33ce0,5a66330,":p1",placeh_len=3,value_p=2605448,value_sz=16,dty=1,indp=1d33d00,alenp=0,rcodep=1d33cf8,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(5a6ef38,5a66330,1d33ca8,2b81e40,1d33ca8,2b81cf0)=SUCCESS OCIAttrGet(5a6ef38,OCI_HTYPE_BIND,1d33cc4,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p1 <== 2 (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0) OCIAttrSet(5a6ef38,OCI_HTYPE_BIND, 23f494,0,Attr=31,5a66330)=SUCCESS dbd_bind_ph(1): bind :p2 <== undef (type 0 (DEFAULT (varchar)), inout 0x2444b30, maxlen 0, attribs: HASH(0x25c8d98)) dbd_rebind_ph() (1): rebinding :p2 as NULL (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 1) OCIDescriptorAlloc(5a30080,1d33ea8,OCI_DTYPE_LOB,0,0) OCIAttrSet(5a63e58,OCI_DTYPE_LOB, 23f3ac,0,Attr=OCI_ATTR_LOBEMPTY,5a66330)=SUCCESS bind :p2 as ftype 113 (SQLT_BLOB / long) OCIBindByName(5a6f208,1d33ea0,5a66330,":p2",placeh_len=3,value_p=1d33ea8,value_sz=8,dty=113,indp=1d33ec0,alenp=0,rcodep=1d33eb8,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(5a6ed48,OCI_HTYPE_BIND,1d33e84,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p2 <== undef (inout, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) dbd_st_execute INSERT (out1, lob1)... Statement Execute Mode is 32 (COMMIT_ON_SUCCESS) OCIStmtExecute(5a661e0,5a6f208,5a66330,1,0,0,0,mode=COMMIT_ON_SUCCESS,32)=SUCCESS OCIAttrGet(5a6f208,OCI_HTYPE_STMT,23f5d4,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS OCIAttrGet(5a6f208,OCI_HTYPE_STMT,23f5d0,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out1) dbd_st_execute(): Analyzing inout a parameter ':p2of type=113 name=SQLT_BLOB / long' ok 4 - returned valid locator OCIHandleAlloc(5a30080,536450,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a733d8,5a66330,'INSERT INTO dbd_ora__drop_me (id,data) VALUES (3, EMPTY_BLOB())',63,1,0)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,536464,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql INSERT ( auto_lob1, check_sql1) dbd_describe skipped for INSERT dbd_st_execute INSERT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(5a661e0,5a733d8,5a66330,1,0,0,0,mode=DEFAULT,0)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f084,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f080,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f0c0,0,OCI_ATTR_ROW_COUNT,5a66330)=SUCCESS dbd_st_destroy OCIHandleFree(5a733d8,OCI_HTYPE_STMT)=SUCCESS dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(5a30080,536450,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a733d8,5a66330,'SELECT data FROM dbd_ora__drop_me WHERE id = :p1',48,1,0)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,536464,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql SELECT ( auto_lob0, check_sql1) dbd_describe SELECT (EXPLICIT, lb 80)... OCIStmtExecute(5a661e0,5a733d8,5a66330,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f14c,0,OCI_ATTR_PARAM_COUNT,5a66330)=SUCCESS OCIParamGet(5a733d8,4,5a66330,51a138,1,OCI_HTYPE_STMT)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a168,0,OCI_ATTR_DATA_TYPE,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a16a,0,OCI_ATTR_DATA_SIZE,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a180,0,OCI_ATTR_CHAR_USED,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a182,0,OCI_ATTR_CHAR_SIZE,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a184,0,OCI_ATTR_CHARSET_ID,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a186,0,OCI_ATTR_CHARSET_FORM,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a16c,0,OCI_ATTR_PRECISION,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a16e,0,OCI_ATTR_SCALE,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a16f,0,OCI_ATTR_IS_NULL,5a66330)=SUCCESS OCIAttrGet(5a730b0,OCI_DTYPE_PARAM,51a170,23f16c,OCI_ATTR_NAME,5a66330)=SUCCESS Describe col #1 type=113(SQLT_BLOB / long) OCIDescriptorAlloc(5a30080,51a148,OCI_DTYPE_LOB,0,0) Described col 1: dbtype 113(SQLT_BLOB / long), scale 0, prec 0, nullok 1, name DATA : dbsize 4000, char_used 0, char_size 0, csid 0, csform 0(0), disize 8 fbh 1: 'DATA' NULLable, otype 113->113, dbsize 4000/8, p0.s0 OCIAttrSet(5a733d8,OCI_HTYPE_STMT, 23f060,4,Attr=OCI_ATTR_PREFETCH_MEMORY,5a66330)=SUCCESS OCIAttrSet(5a733d8,OCI_HTYPE_STMT, 23f0c8,4,Attr=OCI_ATTR_PREFETCH_ROWS,5a66330)=SUCCESS cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=1, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=1, Multiple Row Fetch=Off OCIDefineByPos(5a733d8,51a140,5a66330,1,51a148,0,113,26059e8,2605c58,2605b38,mode=DEFAULT,0)=SUCCESS dbd_describe'd 1 columns (row bytes: 4000 max, 4000 est avg, cache: 0) dbd_st_destroy OCIHandleFree(5a6f208,OCI_HTYPE_STMT)=SUCCESS OCILobIsTemporary(5a30080,5a66330,5a63e58,23f010)=SUCCESS OCIDescriptorFree(5a63e58,OCI_DTYPE_LOB) dbd_bind_ph(1): bind :p1 <== 3 (type 0 (DEFAULT (varchar))) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0) dbd_rebind_ph_char() (1): bind :p1 <== 3 (size 1/16/0, ptype 5(VARCHAR), otype 1 ) dbd_rebind_ph_char() (2): bind :p1 <== 3 (size 1/16, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(5a733d8,1d33dc0,5a66330,":p1",placeh_len=3,value_p=2605448,value_sz=16,dty=1,indp=1d33de0,alenp=0,rcodep=1d33dd8,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(5a73130,5a66330,1d33d88,2b81e40,1d33d88,2b81cf0)=SUCCESS OCIAttrGet(5a73130,OCI_HTYPE_BIND,1d33da4,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p1 <== 3 (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0) OCIAttrSet(5a73130,OCI_HTYPE_BIND, 23f494,0,Attr=31,5a66330)=SUCCESS dbd_st_execute SELECT (out0, lob0)... Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(5a661e0,5a733d8,5a66330,0,0,0,0,mode=DEFAULT,0)=SUCCESS rs_array_init:imp_sth->rs_array_size=1, rs_array_idx=0, prefetch_rows=0, rs_array_status=SUCCESS OCIAttrGet(5a733d8,OCI_HTYPE_STMT,23f5d0,0,OCI_ATTR_SQLFNCODE,5a66330)=SUCCESS dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0) dbd_st_fetch 1 fields... OCIStmtFetch(5a733d8,5a66330,1,2,0)=SUCCESS dbd_st_fetched 1 fields with status of 0(SUCCESS) field #1 with rc=0(OK) 25c8ba0 (field=0): OCILobLocatorPtr=SCALAR(0x25ca0c8) ok 5 - returned valid locator OCIOCILobLocatorIsInit_log_stat(5a30080,5a66330,5a63d68,1)=SUCCESS ok 6 - returned initialized locator OCILobCharSetForm(5a30080,5a66330,5a63d68,0)=SUCCESS OCILobCharSetId(5a30080,5a66330,5a63d68,0)=SUCCESS OCILobWrite(5a661e0,5a66330,5a63d68,23f618,1,273cf28,40000,0,0,0,0,0)=SUCCESS OCILobGetLength(5a661e0,5a66330,5a63d68,23f630)=SUCCESS ok 7 - returned length OCILobCharSetForm(5a30080,5a66330,5a63d68,0)=SUCCESS OCIOCILobFileIsOpen_log_stat(5a661e0,5a66330,5a63d68,23f604,0)=INVALID_HANDLE OCILobRead(5a661e0,5a66330,5a63d68,23f608,1,2746f28,160008,0,0,0,0)=SUCCESS ok 8 - returned written value dbd_preparse scanned 2 distinct placeholders OCIHandleAlloc(5a30080,536250,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a6f278,5a66330,'BEGIN :p1 := DBMS_LOB.GETLENGTH( :p2 ); END;',44,1,0)=SUCCESS OCIAttrGet(5a6f278,OCI_HTYPE_STMT,536264,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql BEGIN ( auto_lob0, check_sql1) dbd_describe skipped for BEGIN dbd_st_finish OCIStmtFetch(5a733d8,5a66330,0,2,0)=SUCCESS dbd_st_destroy OCIHandleFree(5a733d8,OCI_HTYPE_STMT)=SUCCESS OCIOCILobFileIsOpen_log_stat(5a661e0,5a66330,5a63d68,23f010,2355296)=INVALID_HANDLE OCIDescriptorFree(5a63d68,OCI_DTYPE_LOB) dbd_bind_ph(1): bind :p1 <== 40000 (type 0 (DEFAULT (varchar)), inout 0x24c56a8, maxlen 16) dbd_rebind_ph() (1): rebinding :p1 as NULL (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 1) dbd_rebind_ph_char() (1): bind :p1 <== 40000 (size 5/16/16, ptype 5(VARCHAR), otype 1 , inout) dbd_rebind_ph_char() (2): bind :p1 <== 40000 (size 5/32, otype 1(VARCHAR), indp 0, at_exec 1) bind :p1 as ftype 1 (VARCHAR) OCIBindByName(5a6f278,1d33ea0,5a66330,":p1",placeh_len=3,value_p=25823f8,value_sz=32,dty=1,indp=1d33ec0,alenp=0,rcodep=1d33eb8,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS OCIBindDynamic(5a6efd8,5a66330,1d33e68,2b81e40,1d33e68,2b81cf0)=SUCCESS OCIAttrGet(5a6efd8,OCI_HTYPE_BIND,1d33e84,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p1 <== 40000 (inout, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 32, maxdata_size 0) OCIAttrSet(5a6efd8,OCI_HTYPE_BIND, 23f494,0,Attr=31,5a66330)=SUCCESS dbd_bind_ph(1): bind :p2 <== OCILobLocatorPtr=SCALAR(0x25ca0c8) (type 0 (DEFAULT (varchar)), attribs: HASH(0x25ca0e0)) dbd_rebind_ph() (1): rebinding :p2 as NULL (not-utf8, ftype 113 (SQLT_BLOB / long), csid 0, csform 0(0), inout 0) OCIDescriptorAlloc(5a30080,1d33ce8,OCI_DTYPE_LOB,0,0) OCIAttrSet(5a63e58,OCI_DTYPE_LOB, 23f3ac,0,Attr=OCI_ATTR_LOBEMPTY,5a66330)=SUCCESS OCILobLocatorAssign(5a661e0,5a66330,5a63d68,1d33ce8)=SUCCESS bind :p2 as ftype 113 (SQLT_BLOB / long) OCIBindByName(5a6f278,1d33ce0,5a66330,":p2",placeh_len=3,value_p=1d33ce8,value_sz=8,dty=113,indp=1d33d00,alenp=0,rcodep=1d33cf8,maxarr_len=0,curelep=0 (*=0),mode=DEFAULT,0)=SUCCESS OCIAttrGet(5a6ede8,OCI_HTYPE_BIND,1d33cc4,0,31,5a66330)=SUCCESS dbd_rebind_ph(): bind :p2 <== OCILobLocatorPtr=SCALAR(0x25ca0c8) (in, not-utf8, csid 0->0->0, ftype 113 (SQLT_BLOB / long), csform 0(0)->0(0), maxlen 8, maxdata_size 0) dbd_st_execute BEGIN (out1, lob1)... with :p1 = '40000' (len 5(5)/32, indp 0, otype 1, ptype 6) Statement Execute Mode is 0 (DEFAULT) OCIStmtExecute(5a661e0,5a6f278,5a66330,1,0,0,0,mode=DEFAULT,0)=ERROR OCIAttrGet(5a6f278,OCI_HTYPE_STMT,23f4b0,0,OCI_ATTR_PARSE_ERROR_OFFSET,5a66330)=SUCCESS OCIErrorGet(5a66330,1,"",23f060,"ORA-24813: cannot send or receive an unsupported LOB ",1024,2)=SUCCESS OCIErrorGet(5a66330,2,"",23f060,"ORA-24813: cannot send or receive an unsupported LOB ",1024,2)=NO_DATA ok 9 - returned length via PL/SQL # TODO problem reported w/ lobs and Oracle 11.2.*, see RT#69350 dbd_preparse scanned 3 distinct placeholders OCIHandleAlloc(5a30080,536450,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(5a702d0,5a66330,' DECLARE -- testing IN, OUT, and IN OUT: -- p_out will be set to LOWER(p_in) -- p_inout will be set to p_inout || p_in PROCEDURE lower_lob(p_in BLOB, p_out OUT BLOB, p_inout IN OUT BLOB) IS pos INT; buffer RAW(1024); BEGIN DBMS_LOB.CREATETEMPORARY(p_out, TRUE); pos := 1; WHILE pos <= DBMS_LOB.GETLENGTH(p_in) LOOP buffer := DBMS_LOB.SUBSTR(p_in, 1024, pos); DBMS_LOB.WRITEAPPEND(p_out, UTL_RAW.LENGTH(buffer), UTL_RAW.CAST_TO_RAW(LOWER(UTL_RAW.CAST_TO_VARCHAR2(buffer)))); DBMS_LOB.WRITEAPPEND(p_inout, UTL_RAW.LENGTH(buffer), buffer); pos := pos + 1024; END LOOP; END; BEGIN lower_lob(:in, :out, :inout); END; ',738,1,0)=SUCCESS OCIAttrGet(5a702d0,OCI_HTYPE_STMT,536464,0,OCI_ATTR_STMT_TYPE,5a66330)=SUCCESS dbd_st_prepare'd sql DECLARE ( auto_lob1, check_sql1) dbd_describe skipped for DECLARE dbd_st_destroy OCIHandleFree(5a6f278,OCI_HTYPE_STMT)=SUCCESS OCILobIsTemporary(5a30080,5a66330,5a63e58,23f010)=SUCCESS OCIDescriptorFree(5a63e58,OCI_DTYPE_LOB)