What happens if you postpend a null character?

my $zero = "0\0";

Nope:

   SQL> create table foo ( bar number(1,0) );

        SQL> insert into foo (bar) values ( 1 );

        1 row created.

        SQL> insert into foo(bar) values ('2\0');
        insert into foo(bar) values ('2\0')
                                                                 *
        ERROR at line 1:
        ORA-01722: invalid number

Without some knowlege of underlying data types I cannot quote
stringy-numerics so that the database will accept them via
cut+paste from an error message from the vendor's SQL command
line utilities (e.g., sqlplus, shown above).

--
Steven Lembark                                       85-09 90th Street
Workhorse Computing                                Woodhaven, NY 11421
[EMAIL PROTECTED]                                     1 888 359 3508

Reply via email to