Re: Single problem

Or you could use:

connect scott/tiger
alter session set current_schema=schema1;

select * into recordstruct from T1;

would then resolve to schema1.T1

-Kevin

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:fDlL8.2219$b5.19274_at_news.indigo.ie...
> No.
> Schema names in static SQL cannot be hostvars
>
>
> Just make it M4 Dynamic SQL, parse it, describe it, execute it !
>
> (Check Pro*C or PL/SQL supplied packages )
> "Epicentre Team A ANNECY" <djeanneret_at_epicentre.fr> wrote in message
> news:adkgfq$rvt$1_at_wanadoo.fr...
> > Hi
> >
> >
> > We have one schema (environment schema) for many others.
> > Problem is that we must have one environment by instance !.
> >
> > Example
> >
> > Actually the only way is
> > SELECT * from My_env_schem.T1
> >
> > Is possible to have ...
> >
> > Variable_Schema_name := 'My_env_schem1';
> > SELECT * into RecordStruct From Variable_Schema_name.T1
> > Variable_Schema_name := 'My_env_schem2';
> > SELECT * into RecordStruct From Variable_Schema_name.T1
> >
> >
> > Bests regards
> > Epicentre Team A, Denis
> >
> >
>
>
>
Received on Wed Jun 05 2002 - 10:46:14 CDT