Invalid Rowid in OCI using OCIRowid* (O8.0.0.3 & OCI)

 get the error when use this program

st1 : insert into table values (.... )

then after prepare & execute of st1

OCIDescriptorAlloc(env.env,(void**)&rowid,OCI_DTYPE_ROWID,0,0);

OCIAttrGet(st1,OCI_HTYPE_STMT,&rowid,(ub4*)0,OCI_ATTR_ROWID,env.err_handle);

after this i try to reuse the rowid

st2 : select col,col from table where rowid = :ri

prepare statement st2

env.error_c=OCIBindByPos(st,&bind,env.err_handle,1,&_rowid,sizeof(OCIRowid*),SQLT_RDD,0,0,0,0,0,OCI_DEFAULT);

then execute statement st2

and then i get ORA-01410: invalid ROWID

i'm using oracle 8.0.0.3 and OCI and extproc ( data cartridge ) on solaris

--
| Ing. Marco Fuykschot |
| marcof_at_superfluid.com |
| Live, you can hate it , but you can't |
| Love it, by marvin the depressed robot|
Received on Tue May 26 1998 - 10:48:07 CDT