How do i know who has called a pl/sql function inside a procedure when i perform a certain action from fontend(Oracle Apps)?

I have a pl/sql package: FND_PROFILE.

I perform some actions from the frontend, which should trigger calls to FND_PROFILE.VALUE_SPECIFIC

I need to find who has made these calls.

There were suggestions to use PL/SQL Debugger in JDeveloper. Can somebody please help me out?

Answers


use audit

audit execute on FND_PROFILE;

To see who ran some function/procedure in the package query dba_audit_trail


Need Your Help

Rails + Paperclip - NoMethodError in Projects#index - undefined method `image' for nil:NilClass

ruby-on-rails paperclip nomethoderror

I have a rails app with a Project model and a nested Pictures model. Im using the Paperclip gem to upload images to the pictures model, and nested_form gem to nest the Picture model within the proj...

Read back texture coordinates from rendered image in OpenGL?

opengl textures

If I render a scene in openGL, is it possible to get back the texture coordinates that were used to paint that pixel?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.