Skip to Content
0
Former Member
Nov 01, 2007 at 10:38 AM

How to put NULL value into Oracle procedure numeric parameter?

57 Views

Hi!

I need to call oracle procedure which have numeric parameter. I should put NULL value into this parameter. But I don't know how to do it.

I tried following variants:

<p isInput="true" type="NUMERIC">NULL</p>

<p isInput="true" type="NUMERIC"/>

<p isInput="true" isNull="true" type="NUMERIC"/>

Result: Java NumberFormatException in JDBC Adapter

This problem exists only with numeric parameters. For varchar parameter I can put NULL with following method:

<p isInput="true" type="VARCHAR"/>

Thanks for answers.

Best regards,

Eugeny