Home » Developer & Programmer » Forms » Insert image Internal Error
Insert image Internal Error [message #221208] Sun, 25 February 2007 07:41 Go to next message
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
Member
Hi Guys
I am trying to insert a Pict file to the database

code is

eclare
l_blob blob;
l_bfile bfile;
begin
insert into demo values ( 1, empty_blob() )
returning theBlob into l_blob;

l_bfile := bfilename( 'MY_FILES', 'aria.gif' );
dbms_lob.fileopen( l_bfile );

dbms_lob.loadfromfile( l_blob, l_bfile,
dbms_lob.getlength( l_bfile ) );

dbms_lob.fileclose( l_bfile );
end;

I am getting internal error in dbms_lob.fileopen( l_bfile );
Why it is...?

Thanks & Regards
Shefeeq
Re: Insert image Internal Error [message #221274 is a reply to message #221208] Mon, 26 February 2007 02:40 Go to previous messageGo to next message
simple_ora
Messages: 50
Registered: September 2006
Location: UAE
Member
Hi Guys
HOw can I solve this,Its showing intrnal error , I can't catch it ...,Why it so, Any Language or internal setting is to be changed....?
Thanks & regrads
Shefiq.
Re: Insert image Internal Error [message #225383 is a reply to message #221274] Mon, 19 March 2007 19:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Change of used schema
Next Topic: Same Query Gives different result in Same database
Goto Forum:
  


Current Time: Sat Dec 03 05:46:35 CST 2016

Total time taken to generate the page: 0.07424 seconds