Re: [Q] Using Oraperl to INSERT data

ryba_at_ml.csiro.au (Miroslaw Ryba) writes:

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

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

This is because the bind process doesn't translate "" into an Oracle NULL. The best way to do this is with a variable:

     &ora_bind($csr, $name, $phone);

Then you need to make sure that $phone is undefined in perl, ie, do something like: undef $phone;

(Remember, though, that virtually any reference to a variable, even printing it, causes it to be defined.)

Assuming that PHONE is a VARCHAR2 variable in ORACLE 7, then changing your definition to read 'RTRIM(:2)' should work, too. (This should also work in Oracle 6, but I haven't tested it there.)

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)