Conversion question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Conversion question

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question Conversion question

    Could someone give me an example of PL/SQL code that would make the following actions:
    1. Convert a CLOB from WIN1252 to AL32UTF8,
    2. Convert the CLOB to a BLOB,
    3. Use WPG_DOCLOAD.DOWNLOAD_FILE to download the BLOB as a XML file.

    Thank you.

  2. #2
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    The following works:


    -- CONVERTING THE CLOB TO UNICODE THEN TO BLOB
    v_blob := clob_to_blob (NCLOB(v_clob);
    htp.p ('Content-length: ' || length(v_blob));
    ................
    OWA_UTIL.http_header_close;
    -- Download the file
    WPG_DOCLOAD.download_file(v_blob);
    ......

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