Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how can i convert LONG datatype to CHAR

579953Oct 23 2009 — edited Dec 17 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2011
Added on Oct 23 2009
5 comments
3,052 views