Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    16

    Unanswered: Inserting a CLOB value

    Hi All,

    I have the following pl/sql which throwing an error, I am not able to insert data into a table with CLOB value using select.:


    declare
    cursor c1 is
    select distinct id,class
    from test t;

    cursor c2(P_id NUMBER) is
    select id
    from temp;

    begin
    for clr in c1 loop
    for c2r in c2(c1r.id) loop
    insert into xyz
    select id, class, null, document, user, null, sysdate, null
    from abc
    where id = c1r.id;
    end loop;
    commit;
    end loop;
    commit;
    end;


    Thanks a lot for your help.

    Regards,
    namoh

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have the following pl/sql which throwing an error
    and threw it completely off the page to remain unknown to all readers.
    Out of the 10000+ errors Oracle can throw, I don't want to guess which you got.
    You're On Your Own (YOYO)!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2004
    Posts
    16
    Originally posted by anacedent
    >I have the following pl/sql which throwing an error
    and threw it completely off the page to remain unknown to all readers.
    Out of the 10000+ errors Oracle can throw, I don't want to guess which you got.
    You're On Your Own (YOYO)!
    I am sorry guys..my mind has gone blank...
    ORA error is: ORA-00997:ILLEGAL use of LONG datatype.

    Thanks,
    namoh

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Go to http://asktom.oracle.com
    and search on ORA-00997
    Do you realize that a GOOGLE search of ORA-00997 returns only 83 hits?
    Why is it easier to post your question here rather than do you own research?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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