Home » Developer & Programmer » Forms » Error while compiling the form (Forms9i)
Error while compiling the form [message #336752] Mon, 28 July 2008 18:33 Go to next message
former
Messages: 15
Registered: June 2008
Junior Member
Hi,

I have developed a form based on a database of books. The information displayed during run time is Sr No, Book name,Author, Copies, Description and Image(of the book)

I have written a PL/SQL code to display the image of the respective book for every new record. E.g Book1 should display image1, book2 displays image2 and so on. This should happen at runtime. The code is:

declare
gif_image varchar2(80):='c:\ProjectBooks\';
photo_filename varchar2(80);
begin
photo_filename := gif_image||lower(:books.sr_no)||'.gif';
read_image_file (photo_filename, 'gif', 'books.image21');
if not form_success then
message ('The image for this book is currently unavailable');
end if;
:system.message_level:='0';
end;


The error i get during compilation is

Error 49 at Line 5, column 37
bad bind variable 'books.sr_no'


Can somebody guide?

thank you
Re: Error while compiling the form [message #336808 is a reply to message #336752] Tue, 29 July 2008 01:48 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi dear..

The error message explains that there is no item with name " sr_no " in the block " books ".
Check the block name and item name.
There may be some spelling mistake or the item may be in another block.

Regards
Sasi...

[Updated on: Tue, 29 July 2008 01:49]

Report message to a moderator

Re: Error while compiling the form [message #337018 is a reply to message #336808] Tue, 29 July 2008 12:18 Go to previous messageGo to next message
former
Messages: 15
Registered: June 2008
Junior Member
Hi Sasi,

Thanks for the input. I had the item on the canvas but missed it on the block. So, now the form is compiled and runs. But it reads the first image only. For the later images, during run-time, I am getting this error:

FRM 47100: Cannot read image file c:\ProjectBooks\3.gif


Can you guide

thank you
Deepti
Re: Error while compiling the form [message #337051 is a reply to message #337018] Tue, 29 July 2008 14:23 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
FRM-47100: Cannot read image file %s.

Cause:  Caused by one of the following:
1. You specified an invalid parameter list ID.
2. Oracle Forms was unable to find or open the file.
3. The data in the file is not in the specified format.

Action:  Check the file name and file format and try again.
Re: Error while compiling the form [message #472587 is a reply to message #336752] Sun, 22 August 2010 15:13 Go to previous message
Toronto2000
Messages: 1
Registered: August 2010
Junior Member
regarding to FRM 47100: Cannot read image file error message, i face the same issue, the main reason is the size of the image. it works well for 2 KB image size, but not for 2MB, I am still searching for solution.. any body can provide me the solution?
Previous Topic: view the report between two dates
Next Topic: text item in Oracle forms
Goto Forum:
  


Current Time: Mon Dec 05 23:54:08 CST 2016

Total time taken to generate the page: 0.06559 seconds