Re: dyamic table names in embedded SQL in C

Unfortunately, we're using Oracle 7.3. Any ideas?

In article <931937981.6296.0.nnrp-14.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 14 1999 - 16:29:22 CDT