Error while running a form

[deeptic]

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||lowerbooks.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?

Thnx

 

[Turkbear]

Hi,
Where is :books.sr_no defined and how is it getting to the PL/Sql code..Is this a function or a procedure?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[deeptic]

Hi Turkbear,

Thnx for replying. It's a post-query trigger

 

[taupirho]

I need to be clear about this.

In your form you have a block called books and within that block you have a field called sr_no (presumably this field is filled in at run-time onscreen by a user or other process)?

Can you confirm if the above assumptions are correct


In order to understand recursion, you must first understand recursion.

 

[deeptic]

Hi,

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