Home » SQL & PL/SQL » SQL & PL/SQL » cursors and all_tables
cursors and all_tables [message #40850] Thu, 07 November 2002 16:19 Go to next message
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 #40852 is a reply to message #40850] Thu, 07 November 2002 17:06 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4032393532884

Report message to a moderator

Previous Topic: ...wanted a SQL query
Next Topic: cursors and all_tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 03:52:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.