OCI Clob bind

From: Simeon Bailey <s.bailey_at_astracon.com.au>
Date: Sun, 04 Apr 1999 11:12:57 +0800
Message-ID: <3706D8B9.422A6571@astracon.com.au>

Hey :),

    I am attempting to: insert into tablename (empty_clob()) returning clobcol into :val1
I can successfully return SQLT_INT's but SQL_CLOB's cause OCIStmtExec to core dump(in memcpy).
It is not a problem with the callback as it cores before the callback is called.
The err must be in the code below->

status = OCIBindByPos (stmtp, &bindpp, errhp, 1, 0,

            sizeof(OCILobLocator *), SQLT_CLOB, 0, 0, 0,
            0, 0, OCI_DATA_AT_EXEC);

check_status(status);

ub4 pos[1];
pos[0] = 0;

status = OCIBindDynamic(bindpp, errhp, &pos[0],

            cbf_no_data, &pos[0], cbf_get_data); check_status(status);

status = OCIStmtExecute(svchp, stmtp, errhp, 1, 0, (CONST

             OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT); check_status(status);

Any suggestions/advice/examples would be greatly appreciated S. Received on Sat Apr 03 1999 - 21:12:57 CST