Home » Developer & Programmer » Forms » Frm -47105 no image name specified &display error
Frm -47105 no image name specified &display error [message #83855] Sun, 21 December 2003 21:39 Go to next message
Jasmine
Messages: 23
Registered: December 2000
Junior Member
hi
i am trying to insert blob field(a jpeg image ) thru forms

I am getting error
Frm -47105 no image name specified
The get_file_name in not working or the dialog bos is not opening
How to get the flow of the program as we debugger in vc++ any tools
To get the flow of program

How can we specify the image name

declare
filename varchar2(200);
BEGIN
:system.message_level := '25';
filename := GET_FILE_NAME('c:jas',null, 'Jpeg Images (jpg, jpeg)&#124*.jp*g|','save',OPEN_FILE,TRUE);

READ_IMAGE_FILE( filename,'jpg','img.image');
if not form_success then
message( 'Unable to read file "' || filename || '"' );
raise form_trigger_failure;
end if;
END;

Then after I wrote this code
This gives error
Frm -47109 cannot locate file
But the file's in same location
How can we give in double quotes ,single or anything else
When I am trying both ways it giving error cannot locate

Then I getting error


BEGIN
READ_IMAGE_FILE( :img.loc,'jpg','img.image');
if not form_success then
message( 'Unable to read file "' || filename || '"' );
raise form_trigger_failure;
end if;
END;

Pls hlp
jasmine
Re: Frm -47105 no image name specified &display error [message #83856 is a reply to message #83855] Mon, 22 December 2003 00:54 Go to previous messageGo to next message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
Ther's some correction in the code.
declare
filename varchar2(200);
BEGIN
:system.message_level := 25 ;
filename := GET_FILE_NAME(directory_name => 'd:dirname' , File_Filter=> 'JPEG Files (*.jpg)&#124*.jpg|');
READ_IMAGE_FILE( filename,'jpg','img.image6');
if not form_success then
message( 'Unable to read file "' || filename || '"' );
raise form_trigger_failure;
end if;
:system.message_level := 0 ;
end ;

Also chk the size of jpg file.Maybe its too big.Try file size around 8-16 kb.
Re: Frm -47105 no image name specified &display error [message #83862 is a reply to message #83856] Mon, 22 December 2003 20:11 Go to previous messageGo to next message
Jasmine
Messages: 23
Registered: December 2000
Junior Member
i wrote this code but i am geting these errors.Not able to communicate with the file
frm-47105 no image name specofied

unable to read file ""
i think the get_file_name is not working properly
i wrote this in when button pressed of one button in the same block(img).i want to load diffrent files not one

declare
filename varchar2(200);
BEGIN
:system.message_level := 25 ;
filename := GET_FILE_NAME(directory_name => 'd:jas' , File_Filter=> 'JPEG Files (*.jpg)&#124*.jpg|');
READ_IMAGE_FILE( filename,'jpg','img.image');
if not form_success then
message( 'Unable to read file "' || filename || '"' );
raise form_trigger_failure;
end if;
:system.message_level := 0 ;
end ;

any other solutions
pls help
jasmine
Re: Frm -47105 no image name specified &display error [message #83876 is a reply to message #83855] Wed, 24 December 2003 01:21 Go to previous messageGo to next message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
Can you email your form to me..I'll debug it and send it back to u.
Re: ccCOMPILATION ERROR [message #84158 is a reply to message #83862] Sat, 07 February 2004 22:58 Go to previous messageGo to next message
B.NIRANJAN
Messages: 1
Registered: February 2004
Junior Member
when i tried to compile the .pll from oracle 6i to 9i

i am getting the below mentioned error.

Frm -91507 .Pls confirm what's this error

expecting the solution at the earliest as possible.
Re: ccCOMPILATION ERROR [message #84843 is a reply to message #84158] Tue, 04 May 2004 00:27 Go to previous messageGo to next message
anil jha
Messages: 1
Registered: May 2004
Junior Member
don't know
Re: ccCOMPILATION ERROR [message #87822 is a reply to message #84843] Tue, 15 February 2005 01:15 Go to previous messageGo to next message
shahla AFSHAR
Messages: 1
Registered: February 2005
Junior Member
Because you are using your file ".fmx" that you are trying to compile it so it cann't be reopened for whriting.
Solution close your file ".fmx" and retry.
Re: Frm -47105 no image name specified &display error [message #288195 is a reply to message #83855] Sat, 15 December 2007 13:03 Go to previous messageGo to next message
hasnat_kh
Messages: 11
Registered: September 2007
Junior Member
hi ,
i saw ur posting regarding inserting image in database through form. i am facing the same problm i can not insert picture in form. please can you sent me the code for that with some explaination that how u inserted image in form.

Regards,

Re: Frm -47105 no image name specified &display error [message #289131 is a reply to message #288195] Wed, 19 December 2007 18:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at:
About loading and displaying images files
http://cs-netlab-01.lynchburg.edu/courses/Oracle/PPTSlides/08ch.ppt
Save Images in Database From Forms - Download it Here
http://www.orafaq.com/forum/t/60477/67467/
Also
http://www.orafaq.com/forum/m/163347/67693/#msg_163347
Capture image through webcam
http://www.orafaq.com/forum/t/89431/67467/

David
Re: Frm -47105 no image name specified &display error [message #289194 is a reply to message #289131] Thu, 20 December 2007 01:40 Go to previous message
hasnat_kh
Messages: 11
Registered: September 2007
Junior Member
thanks,
Regards
Previous Topic: How to get function keys to work in a modal window
Next Topic: Search button or engine
Goto Forum:
  


Current Time: Sun Dec 04 20:29:08 CST 2016

Total time taken to generate the page: 0.10720 seconds