Re: OCI - Execute Problem

From: John Hatcher <j.hatcher_at_virgin.net>
Date: Sat, 24 Apr 1999 20:22:07 +0100
Message-ID: <7ft5kv$emv$1@nclient3-gui.server.virgin.net>

Hi Uri,

I would suspect there is a constraint on the column PID in the table CONN. Do you actually set a value into the variable before commiting it to the database?

John.

uri bargil wrote in message <37205A49.B6D2C1C1_at_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 Sat Apr 24 1999 - 14:22:07 CDT