Re: updating LONG datatype columns
Date: Wed, 02 Jan 2008 08:24:28 -0800
> 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 =
> 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?
Look up LONG
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Jan 02 2008 - 10:24:28 CST