updating LONG datatype columns
From: uday <uday1067_at_gmail.com>
Date: Wed, 2 Jan 2008 07:27:38 -0800 (PST)
Message-ID: <6e757eda-b904-431f-90bd-fcb0b53bbee8@e10g2000prf.googlegroups.com>
Date: Wed, 2 Jan 2008 07:27:38 -0800 (PST)
Message-ID: <6e757eda-b904-431f-90bd-fcb0b53bbee8@e10g2000prf.googlegroups.com>
i have a column in my database with Long datatype, and i have to
update the values in it.
when i am trying to update it via
UPDATE UM_TB_PD_BU_ACCSS SET nm_prdct_dvsn_id = 1,vc_bsnss_unt_cd =
'1~~8~~11~~82'
WHERE nm_prdct_dvsn_id = 3 AND vc_bsnss_unt_cd = '-1';
oracle issues a "ORA-00997: illegal use of LONG datatype" error.
can some help on this issue? Received on Wed Jan 02 2008 - 09:27:38 CST