OraFAQ Forum: SQL & PL/SQL » cursors and all

Home » SQL & PL/SQL » SQL & PL/SQL » cursors and all_tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cursors and all_tables [message #4089]

Thu, 07 November 2002 16:14

Kelly Goodrich
Messages: 3
Registered: November 2002

Junior Member

Question.
When running as sys and select * from all_tables in cursor in a procedure I get 100 rows.
When running as system and running the same procedure I get 10 rows, just those that have been explicitly granted to system.
Now if I do the same select as system outside of the procedure and not in a cursor I get 100 rows.
Why does it change inside the cursor?

Report message to a moderator

Re: cursors and all_tables [message #4091 is a reply to message #4089]

Thu, 07 November 2002 17:07

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

http://www.orafaq.net/msgboard/plsql/messages/11346.htm

Report message to a moderator

Previous Topic:	cursors and all_tables
Next Topic:	BLOB TOO LARGE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 05:55:59 CDT 2024