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?

uday wrote:
http://tahiti.oracle.com
Look up LONG
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Jan 2, 11:24*am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
uday, I would suggest you look specifically at the Long data type
entry in the Concepts manual chapter on Oracle native data types where
you can find this statement >> You can use LONG columns in SELECT
lists, SET clauses of UPDATE statements, and VALUES clauses of INSERT
statements. <<

HTH -- Mark D Powell --