| Unexpected queries on user_arguments [message #661986] |
Tue, 11 April 2017 01:52  |
 |
praveenpraj
Messages: 21
Registered: October 2011
Location: India
|
Junior Member |
|
|
A report developed in a third party reporting tool causes lot of queries on USER_ARGUMENTS like the below one:-
SELECT argument_name, data_type, data_length, data_precision,
data_scale , in_out
FROM user_arguments
WHERE object_name = 'PROC_INS_TRNS'
AND package_name = 'PKG_FINS_TRNS_DN'
ORDER BY Position
Report uses a package procedure which returns a REF CURSOR.
But while running a single report, it generates a lot of queries on the combination of all the Package and its procedures.
My doubt is whether oracle uses such a query implicitly while getting any calls to its packages.
[Updated on: Tue, 11 April 2017 01:57] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
