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
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