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

Home -> Community -> Usenet -> c.d.o.misc -> Pro*c : insert null integer value in bind variable

Pro*c : insert null integer value in bind variable

From: Fred <fred_at_cf.fr>
Date: 14 Aug 2002 16:47:33 GMT
Message-ID: <2002814-174733-108312@foorum.com>

Hello,

I can't find a way to insert a null integer value in Pro*C : eg, 'pid' is an integer, I would want to insert a NULL value, and not 0

	EXEC SQL
		INSERT INTO foo(cpt, code, dt, pid)
		VALUES (:cpt, :code, sysdate, :pid); 
	EXEC SQL COMMIT;

Thanks in advance.

-- 
Use our news server 'news.foorum.com' from anywhere.
More details at: http://nnrpinfo.go.foorum.com/
Received on Wed Aug 14 2002 - 11:47:33 CDT

Original text of this message

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