1 2 Previous Next 17 Replies Latest reply: Jan 9, 2013 5:07 AM by Purvesh K Go to original post RSS
      • 15. Re: big string issue.
        913578
        Thank you very much Mank..

        This is working!

        But a small issue.. the big string is coming in my stored procedure as an input. i have to break it for 4000 chars and store it in a column.

        The procedure is like this.


        procedure gsm_prc(i_assertion_id in clob)
        is
        begin
        insert into assertion_info (assertion_id) values (i_assertion_id);
        end;
        /

        The datatype of assertion_id is varchar2(4000).
        • 16. Re: big string issue.
          Purvesh K
          Manik wrote:
          This one works in Sqlplus..
          Yes, because of a New line. :)
          • 17. Re: big string issue.
            Purvesh K
            910575 wrote:
            The datatype of assertion_id is varchar2(4000).
            procedure gsm_prc(i_assertion_id in clob)
            is
            begin
            insert into assertion_info (assertion_id) values (i_assertion_id);
            end;
            /
            As you mention Datatype for Assertion_Id is VARCHAR2(4000) but you have declared the variable as CLOB. Also, If I understand correctly, mentioned in other threads, you are trying to convert the VARCHAR2(4000) to CLOB.

            If, you are not able to sync your datatypes, you would surely land in a big trouble.

            My suggestion for your problem is use a
            dbms_lob.substr(i_assertion_id, 4000, 1)
            to fetch only 4000 bytes and store into your table.
            1 2 Previous Next