sir i want insert an image into oracle database through oracle forms 10g as front end by insert statement and after inserting that image into database retrieving that image into oracle forms
through a select statement.

don't give me block level coding i know block level , i want it through coding.

when i am writing select/insert statement in forms then it is showing error in this line
(:block_name.image_itemname).

select image_name into :block_name.image_itemname from scott.myimage where image_id=1;

can any body help me to do this please give me the source code because i am new to oracle forms.

i am waiting for your response....

Views: 237

Reply to This

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…

Continue

Posted by Kirill Loifman on April 15, 2014 at 12:53am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service