SQL & PL/SQL

Hi,

I tried inserting PDF file into a CLOB column , in the below example l_bfile is a bfile datatype.
and I'm inserting l_bfile to CLOB column.

l_bfile := bfilename('C:\test', 'test.pdf');


But It is throwing below error:

ORA-06550: line 9, column 42:
PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got FILE
ORA-06550: line 9, column 1:
PL/SQL: SQL Statement ignored

Please advise me on this.

thanks,
Jagu

Edited by: user11221603 on Oct 11, 2012 6:18 AM