Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    Unanswered: Cannot Insert long file into a CLOB field in Oracle sending file from Unix K shell

    Hi All,

    I am trying to insert large file as CLOB object into CLOB field of Oracle 10g. I am using Unix ksh where the file is prepared and sends the file to stored procedure which tries to insert the file into DB.

    When i am trying it throws an exception ORA-00972: identifier is too long. As i read in some sites that CLOB can store upto 4GB of file.

    Please help with some sample shell script how can i store file as CLOB object to CLOB field in Oracle10g database.

    Its very urgent.


  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL

    Cool Dbms_lob

    Maybe you could find an answer if you read about DBMS_LOB package in the fine Oracle® Database PL/SQL Packages and Types Reference.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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