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

Home -> Community -> Usenet -> c.d.o.tools -> Re: passing null value to callablestatement using java oracle

Re: passing null value to callablestatement using java oracle

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/26
Message-ID: <IyuX4.209846$Tn4.1866808@news1.rdc2.pa.home.com>#1/1

You should be able to pass a null to a SP, you must be trying to reference the value in the SP. Check to verify that it isn't null before you try and use it.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
<ljunquera_at_my-deja.com> wrote in message news:8gjctr$9cv$1_at_nnrp1.deja.com...

> I have a sp with a nullable date field. How do I set a field in a
> callable statement to be null? I get a null pointer exception if I
> pass a null.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri May 26 2000 - 00:00:00 CDT

Original text of this message

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