RE: What is the result of this

Try

create or replace procedure bubba.go ...

Which will then be executed as

Exec bubba.go

Which will run under bubba's security domain and will see the index.

When you are done drop the procedure.

Ian

-----Original Message-----
Sent: Wednesday, April 16, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L

> -----Original Message-----
>
> It will stack the call and use more and more resources, check
> the size of
> the session PGA.
> You can do recursivity with SQL.

I'm fiddling with it. The thing I originally sent was just a skeleton idea. After putting a little meat on the bones, it doesn't seem to be problem in the test database (of course, everything always works in the test database). One thing I discovered is that I can't run it as system to drop the index from bubba's schema. It always says the index does not exist. It doesn't like the BUBBA.INDEX_NAME. I have to run it as bubba and drop INDEX_NAME. I've not checked the PGA size while it was running; I'll see about doing that.

>
> Jared, you should ask about recursivity with SQL in your interviews.
>

And ask about the usefulness of the command rm -rf *

(especially when run in the / directory)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).