RE: Using ALL_CONS_COLUMN view inside a function

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

--
http://www.freelists.org/webpage/oracle-l