[Info-Ingres] TRACING PROCEDURES

[Jürgen Cappel]

I do it by logging (with timestamp) all events of interest
in a table with the appropriate columns. Simple inserts
into the "trace table".



-------- Original Message --------
Subject: 	[Info-Ingres] TRACING PROCEDURES
Date: 	27 Apr 2007 06:27:20 -0700
From: 	npiet at gascognelaminates.com
Organization: 	http://groups.google.com
To: 	info-ingres at kettleriverconsulting.com
Newsgroups: 	comp.databases.ingres



Does anyone know how to trace the execution of dbms
procedures ? We would like to trace the queries in a procedure.

the PRINTQRY option in II_EMBED_SET gives only the name of the
procédure and the parameters passed (when the procedure is called by
an execute procedure)

if the procedure is called by a rule, nothing appears with the
printqry.

thank you for advance

_______________________________________________
Info-Ingres mailing list
Info-Ingres at kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070427/a2349193/attachment.html