Re: updating LONG datatype columns

uday wrote:
> 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?

http://tahiti.oracle.com
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.org