Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    34

    Unanswered: dbms_lob.substr error

    Hi

    How to get around with this . database is 817
    We have a table lobsq(col clob).

    select dbms_lob.getlength(col) from lobsq
    gives me 4245.

    my plsql program is likt this

    declare
    res varchar2(32767);
    begin
    select dbms_lob.substr(col,dbms_lob.getlength(col),1) into res from lobsq;

    dbms_output.put_line(res);
    end;

    gives me the following error
    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error
    ORA-06512: at "SYS.DBMS_OUTPUT", line 57
    ORA-06512: at line 10

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    15
    If calling the CLOB function in select statement, then limitation is 4000 charcters, since the CLOB data will be converted to varchar2 and this is identified as limitaion in SQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •