Re: Single problem

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Wed, 5 Jun 2002 11:22:02 +0100
Message-ID: <fDlL8.2219$b5.19274@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 - 05:22:02 CDT