How to add data to CLOB type column with using stored procedure?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to add data to CLOB type column with using stored procedure?

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    99

    How to add data to CLOB type column with using stored procedure?

    I hava a table with a clob column.I want to add data to this column with stored procedure.I tried this as follows.
    create table try1(
    a clob
    )
    /
    create or replace package tryclob is
    function tryclob(a_ in varchar2) return int;
    end tryclob;
    /
    create or replace package body tryclob is
    function tryclob(a_ in varchar2) return int
    as
    i int;
    begin
    insert into try1 (a) values (a_);
    return 0;
    end;
    end tryclob;
    /
    then I use this fucntion to add data ,the result is
    when I inserted data about 4000 Byte length,the result is right.
    but when I inserted data too long like 8000 Byte or 80000 Byte,the result is wrong. It only inserted 3200 or 4200 Byte into the column.the string is be cutted.
    How can I do
    How can I do to inserted about 80000 BYTE or 800000 Byte into a clob column with the procedure?
    Please,help.
    ocean

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    How about DBMS_LOB package?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Sep 2001
    Posts
    99

    Could you tell me the detail?

    Please help.
    ocean

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  5. #5
    Join Date
    Sep 2001
    Posts
    99

    thanks

    thanks very much
    ocean

Posting Permissions

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



Click Here to Expand Forum to Full Width