Re: Wierd sequence/function failure- SOLVED

Well Thomas, you called it. Thank you, Thank you, Thank you. What you wrote jogged my brain. What happened is that the application I am putting together has several years of legacy data to be added. The job numbers for the old system have leading 0's, but the new jobs do not.. On a whim to make a list of old/new jobs prettier (whims can be very bad things), I deleted the leading zeroes on Sunday. Unfortunately, there was an old record with a job number of 0 which turned into ' ' when I deleted the leading zeroes, which then caused my problem. I changed the id back to 0 and everything is fine now. Whew, that would have been hairy on my own. Give yourself a pat on the back.

Kathy Graham

Thomas Kyte wrote:

> ...much text removed....Thomas Kyte wrote:
>
> I think that if you look at job_id, some of the values will not be numbers and
> thats the issue. Consider:
>
> SQL> create table test( x varchar2(5) );
> Table created.
>
> SQL> insert into test values ( 1 );
> 1 row created.
>
> SQL> select * from test where x = 1;
>
> X
> -----
> 1
>
>
> ...
Received on Wed Feb 17 1999 - 18:21:02 CET