Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Tokyo
    Posts
    10

    Question Unanswered: how to assign varchar2 to CLOB

    hi guys

    In one of my PL/SQL procedures I need to do the following:

    myCLOB := field1 || field2 || field3

    Where myCLOB is a CLOB varibale and field1, field2, ....fieldn are varchar2 fields which i select from database. I need to select FIELDS, concatenate them, assign them to myCLOB and send myCLOB back as an OUT parameter.

    but it doesnt let me assign a varchar2 to CLOB.

    The reason I want to use CLOB is the size of data, it may be more than 50,000 characters.

    Any solution for this problem??


    thanx in advance
    Omer
    Omer Imtiaz

  2. #2
    Join Date
    Oct 2003
    Posts
    87
    variableString schema.tableName.myCLOB%TYPE
    variableString := field1||field2||field3
    Oracle - DB2 - MS Access -

Posting Permissions

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