Re: Howto Create global temporary table in Oracle 8.0.5

Jimbo1 wrote:
> You can't create Global Temporary Tables in Oracle 8.0. They were a new
> feature in 8i.
>
> You need to forget this option. Also, as somebody pointed out above,
> you could just do what you're trying to do in your trigger by using a
> PL/SQL table or another type of collection.
>
> As far as I know, PL/SQL tables, Nested Tables and Varrays were
> supported in 8.0, but they've had a lot of newer features added since
> then.
>
> I know upgrading is not a straightforward option, i.e. it's not
> something you can just do as a quick fix one morning, i.e. "I've got a
> problem in an app with a non-existent feature in Oracle 8.0. What can I
> do? I know, I'll just upgrade the database. Yep, that's totally
> straightforward. Job done.". Oracle upgrades are not straightforward,
> and have to be done very carefully.
>
> Just use the PL/SQL features available to you in 8.0. PL/SQL was still
> a very robust language even then, so you shouldn't have any real
> problems.
>
> If you'd like any pointers, feel free to ask.
>
> Cheers.
>
> James

thanks James,

Here is my problem in Oracle 8.0,

I have two triggers on same table

-> Before Delete

     I'd like to store each line would be deleted
     into a table --> insert into table a ...;
-> After Delete
     I'd like to do one operation on the rows
     deleted before I'd flush these data.

As you said I cannot upgrade oracle to 8i I use this trick in Oracle 8i
global temporary table ...
on commit delete rows;

How can I do the same trick in Oracle 8.0?

Thank you very much for your time

Claude
ciao ciao Received on Thu Dec 15 2005 - 07:00:26 CST