Home » Developer & Programmer » Forms » Getting program name in PL/SQL (8i, Win XP)
Getting program name in PL/SQL [message #348227] Tue, 16 September 2008 02:24 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
Hi

In a trigger I want to store the application name that did a change (update,insert or delete) on a table.

I have used program and module from table v$session, however this does not return any values if the user does a change via the menu ie. if the user changed a field using form XYZ.frm, XYZ is not returned through v$session.

Any ideas how I can get the application name from the menu.

Thks.

Re: Getting program name in PL/SQL [message #348231 is a reply to message #348227] Tue, 16 September 2008 02:56 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In Forms, you'd use the :SYSTEM.CURRENT_FORM system variable.
Re: Getting program name in PL/SQL [message #348241 is a reply to message #348231] Tue, 16 September 2008 03:33 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
How would I get the program name in a stored database trigger.
Re: Getting program name in PL/SQL [message #348264 is a reply to message #348241] Tue, 16 September 2008 04:11 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Form name in a stored database trigger? Perhaps there is a way to do that, but I don't know anything about it. If you wish, you could research use of the OWA_UTIL.WHO_CALLED_ME; I didn't use it with Forms, but you might give it a try.
Re: Getting program name in PL/SQL [message #348267 is a reply to message #348264] Tue, 16 September 2008 04:34 Go to previous message
Derek N
Messages: 80
Registered: September 2002
Member
Thanks. Just read something on SYS_CONTEXT, gonna read up on that too.
Previous Topic: Block Where Clause Problem
Next Topic: How to use the host command to send mail in Forms 6i through PLSQL
Goto Forum:
  


Current Time: Sun Dec 11 00:33:45 CST 2016

Total time taken to generate the page: 0.07730 seconds