[Q] Using Oraperl to INSERT data

Dear Fellow Netters,

I am trying to load data into an Oracle table using Oraperl. It goes like this:

...

  # open cursor
  $csr = &ora_open(lda, "insert into phonelist values (:1, :2)");   # insert data
  &ora_bind($csr, "Anette", "5336");
  &ora_bind($csr, "Brigitte", "6258");
...
...

It works fine as long as none of the data items is NULL, i.e.:

   &ora_bind($csr, "Tom", "");

results in: ORA-01722: invalid number ...

Assuming that it is OK to have null telephone numbers, how should it be done? Any advice gratly appreciated.

Miroslaw

Miroslaw Ryba                     _--_|\        ryba_at_ml.csiro.au 
CSIRO Marine Laboratories        /      \       tel +61 02 325 336 
PO Box 1538   Hobart 7001        \_.--._/       fax +61 02 325 000
Australia                              v