Re: triggers and finding calling parent

From: Ronald <devnull_at_ronr.nl>
Date: 11 Mar 2003 06:59:21 -0800
Message-ID: <67ce88e7.0303110659.27e17d0@posting.google.com>

sharkdba_at_yahoo.com (Sharkie) wrote in message news:<423b5ab1.0303101547.3c5979f6_at_posting.google.com>...
> If there is a stored procedure, oracle job, or even a sql+ console,
> that calls a query, does oracle know this? In other words, would
> the trigger know where the statement was coming from? And if yes,
> how can I access this information? Even a process ID, anything would
> be helpful.
>
> Any other ideas on how a change to a table can be tracked?

I think you could give this a try:

FORMAT_CALL_STACK Function
This function formats the current call stack. This can be used on any stored procedure or trigger to access the call stack. This can be useful for debugging.

Syntax
DBMS_UTILITY.FORMAT_CALL_STACK
RETURN VARCHAR2; Parameters
None.

Pragmas
pragma restrict_references(format_call_stack,WNDS);

Returns
This returns the call stack, up to 2000 bytes.

Ronald.

http://ronr.nl/unix-dba Received on Tue Mar 11 2003 - 08:59:21 CST