utl_file.put_raw

[Goffman]

Hello,
Is there any abilitity to write into BFile binary data using DOA?
There is implemented UTL_FILE.PUT_LINE, but PUT_RAW is not

 

[Marco Kalter]

To use utl_file.put_raw you can use a TOracleQuery with a corresponding PL/SQL Block:

begin
  utl_file.put_raw(:file_id, :raw_data);
end;

The :file_id variable is an integer holding the id of the file that was previously opened. The :raw_data is a string that holds the raw data in hexadeximal format.

 

[Goffman]

Thanks,
But it doesnt work with :file_id
I made it like this

declare
  fh sys.utl_file.file_type;
begin
  fh:=utl_file.fopen(:directory,:file_path,'w');
  utl_file.put_raw(fh, :raw_data);
  utl_file.fclose(fh);
end;