varchar to long convertion
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: varchar to long convertion

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    varchar to long convertion

    Hi friends ,

    we have a column with width varchar2(4000) ,

    we want to increase width to 6000 characters ....

    if we migrate to LONG DATATYPE
    how to use insert and select more than 4000 characters in sqlplus .

    this column is extensively used in application ...

    Thanks for your feedback .

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi

    I tested in 8.1.6 a,d 8.1.7 databases creating
    LONG COLUMN AND CLOB .

    using insert statement we can insert upto 4000 characters .
    if we try to insert more than 4000 characters . it throws following error message

    ORA-01704: string literal too long.
    in both the cases ..

    is there any workaround for this ... so that we don't need to change entire application and we can use direct insert statement to insert more than 4000 characters .

    our application uses insert statement directly ...

    thanks for any kind of suggestions

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Use PL/SQL. It has a limit of 32000 characters (I think). More than this, you might have to use the OCI calls.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Also try dbms_lob package
    dbms_lob.load_from_file ??

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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