Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Mahesh.

Asked: August 29, 2016 - 3:36 am UTC

Last updated: August 29, 2016 - 12:26 pm UTC

Version: 11g

Viewed 1000+ times

You Asked

I have a entry in v$sql - SELECT ORG_ENTITY_ID FROM MS_QMS_FLOW_DOWN_ORG_V WHERE ACTIVITY_NAME = :B2 AND UPPER(USER_NAME) = UPPER(:B1 ). Is there a way to find out which Package/Procedure caused this Select statement to run ?

PS: I am new to the forum so pls forgive if I have not given enough information

and Connor said...

Easy to do if it is inside a PLSQL program

Check out this blog post of mine

https://connormcdonald.wordpress.com/2016/01/20/problematic-sql-plsql-is-your-friend/



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library