Error while compiling the form [message #336752] |
Mon, 28 July 2008 18:33 |
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 #337018 is a reply to message #336808] |
Tue, 29 July 2008 12:18 |
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 #472587 is a reply to message #336752] |
Sun, 22 August 2010 15:13 |
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?
|
|
|