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 -> OCI - Execute Problem

OCI - Execute Problem

From: uri bargil <uri_at_trans-planet.com>
Date: Fri, 23 Apr 1999 14:32:25 +0300
Message-ID: <37205A49.B6D2C1C1@trans-planet.com>


Hello
Im working on Oracle 8 DB and OAS 4.0.7 on SUN SOLARIS 2.6. I try to implement an INSERT as follows: "INSERT INTO CONN (PID , CID , VID) VALUES (:PID , :CID , :VID )". All the preparation for the execution passes correctly , including the StmtPrepare , BindByame.
The OCIStmtExecute fails with this error : ORA 01400 - cannot insert NULL into ("SYSTEM" ."CONN".PID) PID is a VARCHAR2 in the DB , and it is bind to a (text *) variable in my code.
What is the reason for this problem and how can I solve it? Uri. Received on Fri Apr 23 1999 - 06:32:25 CDT

Original text of this message

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