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; 
    --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 



    Friday, November 12, 2010 8:12 AM

All replies