Re: dyamic table names in embedded SQL in C

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Jul 1999 08:33:05 +0100
Message-ID: <931937981.6296.0.nnrp-14.9e984b29@news.demon.co.uk>

It would help if you told us the version of Oracle.

If you are running 8.0 or 8.1 you might want to look at my website for articles on PL/SQL tables or PL/SQL arrays, and rethink your strategy of using real physical tables. (For 8.1 you might also consider proper 'GLOBAL TEMPORARY' tables).

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

shockerman_at_my-deja.com wrote in message <7mgbbj$v96$1_at_nnrp1.deja.com>...
>I'm going to have people using this program simultaneously on the web
>so every time they run the program, I need to create a unique table for
>them. I thought of using the userenv('sessionid') from dual and then
>doing a command like this. It ends up making a table name called
>sorted_sessionid. Pro*C won't let me do
>create table sorted_:sessionid which would make my life so much
>easier.
Received on Wed Jul 14 1999 - 02:33:05 CDT