OraFAQ Forum: Forms » Insert image Internal Error

Home » Developer & Programmer » Forms » Insert image Internal Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert image Internal Error [message #221208]

Sun, 25 February 2007 07:41

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

Report message to a moderator

Re: Insert image Internal Error [message #221274 is a reply to message #221208]

Mon, 26 February 2007 02:40

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.

Report message to a moderator

Re: Insert image Internal Error [message #225383 is a reply to message #221274]

Mon, 19 March 2007 19:03

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 13:03:05 CST 2025