Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log writer procedure

Status
Not open for further replies.

sadiik

Programmer
Feb 13, 2006
2
ES
Hi all!
I need to create a "log writer" procedure which can be called for every store procedure in de database, but it must be "transaction independent" because I could call this "annotation utility" several times in the same "work unit". Ej:

CREATE PROCEDURE BDI.PRUEBAS
P1: BEGIN
insert into bdi.lines values ('90519','ITEM');
call bdi.agregate_data;
call bdi.csii_log('Data agregated',00.0);
call bdi.alter_data;
call bdi.csii_log('Data altered',00.0);
rollback;
END P1

This example has not more sense, but i'm making tests. :p

The final idea is to call diferente process from one master process and rollback all the work if something fails, but i need to get a log of the diferent steps..... And i would like this "log writer" will be "independent".

Could someone help me please? I don't see a solution.

Thanks a lot and sorry for my english :)
Juan Carlos


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top