-
Show Image in Form
Hi,
I have some picture stored in a table,
table t_picture
id, picture
1 pic1.jpg
2 pic2.jpg
3 pic3.jpg
I want to show these picture in form (image item) after I enter the id. I do this in next_item_trigger
exp : select picture into :block.picture from t_picture
where id = :block.id;
it show an error : bad bind variable.....
Anybody can help me, please?
Regards,
Ching
ching
-
Nope, PL/SQL has ** NO ** datatype to deal with images. In Forms, you MUST have an Image Item inside some block, and your code will be NOT a SELECT, but a READ_IMAGE_ITEM into that :block.imageItem, see in the Form Builder on-line help the complete syntax for READ_IMAGE_ITEM.
Regards,
Chiappa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|