RE: Using ALL_CONS_COLUMN view inside a function
- From: "Koppelaars, Toon" <T.Koppelaars@xxxxxxxxxxxxxxxxxxxx>
- To: <hammerl@xxxxxxxxxxxxxxx>
- Date: Tue, 28 Aug 2007 08:23:47 +0200
Brett,
>>The value returned inside a function is 27 while the query returns
703.
Embedded SQL inside stored modules (functions, procedures, triggers or
packages) will not use additional privileges that may have been acquired
through database roles.
Does your session have roles set, when you run the query (outside the
function)?
What happens if you do a 'set roles none', prior to running the query.
Is then returning 27 (as is the query when run inside the function)?
Toon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
