> does anyone know how to kernel trace procedures or triggers?
When you choose to trace by insert statements, you can use a special option to CREATE
TABLE: IGNORE LOG. Operations on such a table are not affected by a ROLLBACK.
Example (in Python):
session = sapdb.sql.connect ('SUT', 'SUT', 'SUT73')
session.sql ("""create table TEMP.notlogged (
"when" timestamp key default timestamp,
line char (255)) ignore log""")
session.sql ("insert into temp.notlogged (line) values ('this is some trace')")
for row in session.sql ('select * from temp.notlogged'):
print row
print 'doing rollback'
session.rollback ()
for row in session.sql ('select * from temp.notlogged'):
print row
Advantage: you can trace multiple calls without the risk of losing some trace due to a
ROLLBACK
Disadvantage: It has to be a TEMP table, so you cannot acces the data from another
session.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
