Re: Can't write Null into nullable field?

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Thu, 06 Jan 2000 20:49:09 GMT
Message-ID: <9d7d4.5033$eQ2.175776@news1.rdc2.on.home.com>

Rich
Try :

update content set prev_content_id=NULL where content_id = 3070

Thomas Olszewicki

"Rich Gilmour" <richg_at_aaepa.com> wrote in message news:3874F5B1.35B4B4A5_at_aaepa.com...
> Hello everyone. Using SQL Worksheet, I typed the following :
>
> SQLWKS> describe content
>
> Column Name Null? Type
>
> ......blah blah foo biz baz
>
> PREV_CONTENT_ID NUMBER(9)
> NEXT_CONTENT_ID NUMBER(9)
>
>
> Fine. I then attempt the following :
>
> update content set prev_content_id = 'Null' where content_id = 3070
>
> ...and get the following error message : ORA-01722: invalid number
>
>
> From the looks of the description of this table, prev_content_id is
> nullable, yet I get an error trying to save Null into this field. Could
> someone please shed some light on this one?
>
> Thanks very much in advance,
>
> Rich
>
Received on Thu Jan 06 2000 - 14:49:09 CST