locked
Direct download from BLOB column RRS feed

  • Question

  • User-1740349212 posted

    Hi, friends.

     

    i need to download a file directly from a table's BLOB column .

    i used this procedure, but i got the error:

    SQL> exec download_blob;

     

    begin download_blob; end;

     

    ORA-06550: line 2, column 7:

    PLS-00905: object IFRSCD.DOWNLOAD_BLOB is invalid

    ORA-06550: line 2, column 7:

    PL/SQL: Statement ignored 

     

    The code is:

    create or replace procedure download_blob() is 
    myblob blob; 
    begin 
    
    --Select the BLOB out of mytable using the name argument 
    select dem.arq_file into myblob from CAD_SCD_DEMANDAS dem where dem.cod_idscd_demandas = 0; 
    
    --Initiate Direct BLOB download 
    wpg_docload.download_file(myblob); 
    end; 
    /


     

     

    Friday, November 12, 2010 8:12 AM

All replies