I want to download blob image from db to client I am using below code in a button when i press button i get this error: ORA-04067
Any one please help.
vfilename varchar2(120) := 'J:\img'||:employees.employee_id||to_char(sysdate,'DDMMRRRR_HH24MISS')||'.jpg';
'employee_id = '||:employees.employee_id,
'Downloading from Database',
'Wait to Complete');
client_host('cmd /c start '||vfilename);
Thanks for response!
I compiled the webutil_db package in database and it is in the forms user schema, i got the same error message as i get in the forms
actual error message is both in db compilation and in the forms execution
ora-04067 not executed, package body "<user>.webutil_db" does not exist.
Package is the object of same user scheme even then execute should be granted to that user
in db compilation it also give this error
ORA-06508: PL/SQL: could not find progaram unit being called "<user>.webutil_db"