oci & OCI_ATTR_STMT_TYPE

From: stef <stef.pellegrino_at_gmail.com>
Date: 25 Jun 2006 08:12:40 -0700
Message-ID: <1151248360.552922.4080@c74g2000cwc.googlegroups.com>

Hello,

under Oracle 10g with a little C program, I want to know what kind of query I have, but after doing

sql = "exec mysp(:my_refcursor);";

OCIStmtPrepare(dbproc, err, sql, strlen(sql), OCI_NTV_SYNTAX, OCI_DEFAULT);

//

// >>>> stmt_query_type gives me... 0 !! (and no error)
//
r = OCIAttrGet(dbproc, OCI_HTYPE_STMT, &stmt_query_type, 0, OCI_ATTR_STMT_TYPE, errh);

I do not see this value in Oracle documentation (just OCI_STMT_SELECT, etc...) Received on Sun Jun 25 2006 - 10:12:40 CDT