Re: Temporary table, DynamicSQL Cursor

In article <881d5scor390s43n6mcktq5shen94hst6s_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> >
> I cannot see any other way to do this. I'd be interested to hear how
you did
> the trick of:
>
> execute( 'drop table T' );
> execute( create table T as select' );
> open some_cursor for select * from t;
>
> in one procedure.... i cannot see anyway to make this work as the
dynamic drop
> would try to invalidate the procedure that does the "open some_cursor
for select
> * from t"
>

I don't get what you mean when you say "the dynamic drop would try to invalidate the procedure that..."
Are you saying that using a drop in a procedure can have consequences further down the like ?
Could you clarify this please.
At the moment when one invokes my foo function at a reasnable rate, it works fine.
By the way the error I get when a high rate invocation of foo function is
ORA-000600 internal error code [kcbgcur_3], [4], [5],[25185326], [14196,],[14198], [1]
follwed by
ORA-04068: existing state of packageds has been discarded

Cheers
JC

>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 08:04:26 CST