Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Running Oracle Reports exe from Portal using PL/SQL

130415Dec 10 2001
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&currency=#&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;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2002
Added on Dec 10 2001
0 comments
91 views