Running Oracle Reports exe from Portal using PL/SQL
Hi!
I have a procedure that calls the Oracle Reports exe in the form
of a "Confirmation" link and then inserts a record in a table.
Is there anyway and I can stop the record being inserted if the
Confirmation link is not clicked, or the exe fails? Here's the
code:
htp.p('Please confirm that the client
is : '||v_title||' '||v_forename||' '||v_surname);
htp.br;
htp.p(htf.anchor('http://10.60.3.3/scripts/rwcgi60.exe?
server=repservernew.world&report=\\10.60.3.3
\Oracle\Reports\'||in_report_name||'&userid=user/pword@mydb&desty
pe=file&desformat=PDF¤cy=#&desname=\\10.60.3.3
\oracle\citiloans\'||cust_id||'.pdf&customer_id='||cust_id, 'Prin
t Now'));
BEGIN
INSERT INTO notes_table
(customer_id,note)
VALUES (cust_id, 'Letter Sent :-
'||v_letter_description);
END;