OraFAQ Forum: Forms » Getting program name in PL/SQL

Home » Developer & Programmer » Forms » Getting program name in PL/SQL (8i, Win XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting program name in PL/SQL [message #348227]

Tue, 16 September 2008 02:24

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.

Report message to a moderator

Re: Getting program name in PL/SQL [message #348231 is a reply to message #348227]

Tue, 16 September 2008 02:56

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In Forms, you'd use the :SYSTEM.CURRENT_FORM system variable.

Report message to a moderator

Re: Getting program name in PL/SQL [message #348241 is a reply to message #348231]

Tue, 16 September 2008 03:33

Derek N
Messages: 80
Registered: September 2002

Member

How would I get the program name in a stored database trigger.

Report message to a moderator

Re: Getting program name in PL/SQL [message #348264 is a reply to message #348241]

Tue, 16 September 2008 04:11

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: Getting program name in PL/SQL [message #348267 is a reply to message #348264]

Tue, 16 September 2008 04:34

Derek N
Messages: 80
Registered: September 2002

Member

Thanks. Just read something on SYS_CONTEXT, gonna read up on that too.

Report message to a moderator

Previous Topic:	Block Where Clause Problem
Next Topic:	How to use the host command to send mail in Forms 6i through PLSQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 16 03:44:31 CDT 2026