Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error while running a form

Status
Not open for further replies.

deeptic

Programmer
Jul 28, 2008
4
US
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?

Thnx



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



[profile]

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

Thnx for replying. It's a post-query trigger
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top