Re: Howto Create global temporary table in Oracle 8.0.5

From: Jimbo1 <nightfanguk_at_yahoo.co.uk>
Date: 15 Dec 2005 04:08:44 -0800
Message-ID: <1134648524.362745.44430@g44g2000cwa.googlegroups.com>

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 Received on Thu Dec 15 2005 - 06:08:44 CST