Home » SQL & PL/SQL » SQL & PL/SQL » Oracle PL/SQL Batch Processing Reports
Oracle PL/SQL Batch Processing Reports [message #312076] Mon, 07 April 2008 22:45 Go to next message
ttkong
Messages: 2
Registered: March 2008
Location: Malaysia
Junior Member
Hi all,

It is very common in batch processes where reports are generated at the same time. Those reports could include exceptional/error report, successfully processed transaction report and others.

Can anyone help to explain how Oracle PL/SQL or any other method or available tool that can achieve the above? I need the PL/SQL processes to update transaction and at the same time generate report.

Thank you very much.

Rgrds,
ttkong
Re: Oracle PL/SQL Batch Processing Reports [message #312077 is a reply to message #312076] Mon, 07 April 2008 22:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I need the PL/SQL processes to update transaction and at the same time generate report.
Write the PL/SQL to meet the agreed upon business requirements.
Re: Oracle PL/SQL Batch Processing Reports [message #312078 is a reply to message #312076] Mon, 07 April 2008 22:56 Go to previous message
bibsdash
Messages: 47
Registered: April 2008
Member
Try this way:

declare
...
begin
 update abc
 set ...
 commit;
end;
-- start showing report
set verify off

spool abddetails.log

ttitle "This is my report title"

select * from abc;

spool off

exit;

[Updated on: Mon, 07 April 2008 22:59]

Report message to a moderator

Previous Topic: How to add sysdate to the output file(spool) name in sqlplus
Next Topic: Invoke Oracle Form from PLSQL
Goto Forum:
  


Current Time: Thu Dec 12 23:57:20 CST 2024