5 Replies Latest reply on Dec 17, 2010 9:45 AM by 803439

    how can i convert LONG datatype to CHAR

      Hi Friends
      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