Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OCIBindByPos Problem

OCIBindByPos Problem

From: Marco Fuykschot <marcof_at_superfluid.com>
Date: Thu, 07 May 1998 15:35:08 +0200
Message-ID: <3551B88B.18233FAA@superfluid.com>


Hello to the reader of this message,

The problem is:

i got in C an buffer of chars ( char* buffers) , there are 5 char in this
buffer: 0 , 0 ,3 , 5 ,8

i binded the this buffer on the first slot of this statement "insert into tmp_new_table values ( :pos1 )" using this call

OCIBindByPos(st,&bind,error_handle,1,buffers,1,SQLT_INT,0,0,0,0,0,OCI_DEFAULT);

And when i execute this using the following code

 error_code=OCIStmtExecute(ses,st,error_handle,5,0,0,0,OCI_DEFAULT);

All goes fine

but when i do a select * from tmp_new_table in SQLplus i get the following results


               3
             117
             116
              95
              98

I'm using Oracle 8.0.0.3 on SunOS5.5.1

--
| 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 Thu May 07 1998 - 08:35:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US