how can i convert LONG datatype to CHAR
579953Oct 23 2009 — edited Dec 17 2010Hi Friends
Hi,
I want to bring a view from one schema to another schema . For that i have a PLSQL script with an explicit cursor performing a select on ALL_VIEWS. The script is getting an error on the cursor fetch because it's trying to access the TEXT column from ALL_VIEWS, which is a LONG datatype.
error is ORA-06502: PL/SQL: numeric or value error.how can i access a long column in a cursor.. or any other way to create the view which is existing in other schema..?
Any solution for this problem..
Thanks and regards
Aneesh