Get program name oracle

October 27, - am UTC. I would call that "a product issue", doesn't seem right -- have you contacted support? Metalink to the rescue!

It's a known issue, apparently, and one of the recommended workarounds is to create a table and have every program unit perform an INSERT into it to create a breadcrumb trail. Helpfully, they go on to suggest the use of a package if one wishes to keep the stack trace private to a session. A reader, January 20, - pm UTC. January 20, - pm UTC.

I did stumble over the same problem, when I accessed the code through an other thread. TIA, eugen. November 10, - pm UTC. Requesting again.

Rahul, November 27, - pm UTC. Can you please update the code link whenever you can to the new code? Thank you, Rahul. November 27, - pm UTC. Tom, You already gave us the better version. Anyway, I tested this snippet of code you gave in the thread couple of posts ago. So, I tested it like this. Shivaswamy, November 30, - am UTC. Tom, I get page not found for "Who called me" function.

Would you mind giving the link, if it is still there? November 30, - pm UTC. The current version Tom has demonstrated only returns the owner. I wanted a call that would dynamically get me whoami for assignment to a constant to use with generic error handling. NOTE: I know it's a bit clunky but it seems to work well whether your proc takes arguments or not. March 15, - am UTC. What are your thoughts? July 12, - pm UTC. You can use that if you like. Never Mind. Rahul, July 12, - pm UTC.

AND fcpt. WHERE fcp. AND frgu. AND fr. AND frt. NVL fu. WHEN fcr. WHERE fcr. AND fcr. Email This BlogThis! Share to Twitter Share to Facebook.

Share this article :. Dennis Jeans 9 September at Aftab Shaikh 30 October at LL 23 September at Egotistical Giraffe 1 October at Quickbooks Expert 25 January at Mom is Love 19 February at Jamesy 13 June at Bangalore Escorts 14 June at Ana Watson 28 June at Hileli Oyun İndir 7 August at Aftab Shaikh 21 August at Job ID of the current session if it was established by an Oracle Database background process.

Null if the session was not established by a background process. This attribute is used by various database components to identify lightweight application users who authenticate as the same database user. Name of the default schema being used in the current schema. You can specify these attributes only inside the event handler for the fine-grained auditing feature. The length of the current SQL statement that triggers fine-grained audit or row-level security RLS policy functions or event handlers.

Valid only inside the function or event handler. The current audit entry number. The audit entryid sequence is shared between fine-grained audit records and regular audit records. You cannot use this attribute in distributed SQL statements. The correct auditing entry identifier can be seen only through an audit handler for standard or fine-grained audit.

Job ID of the current session if it was established by a client foreground process. Null if the session was not established by a foreground process. Returns the way the user's schema was created in the database. In the list that follows, the syntax used during schema creation is followed by the identification type returned:. Returns TRUE if the user has been authenticated as having DBA privileges either through the operating system or through a password file.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.