Re: CONNECT STRING

From: John Koo <johnkoo_at_i-wave.net>
Date: Mon, 14 Sep 1998 22:16:25 +0800
Message-ID: <35FD2539.1BCFE32B@i-wave.net>

Hey Brian, you may read documents related to dynamic PL/SQL parsing & execution. hint: dbms_sql...

Brian Everett wrote:

> Greetings All!
>
> I'm attempting in PL/SQL to dynamically
> assign a connect string based on information
> about which server should be written to from
> a table of information. It seems that
> parsing the information to a string variable and
> using that in a select statement won't do the trick.
>
> i.e. select * from table || '@' || connect_string || ';'
>
> Even building the string before the select statement seems to fail.
>
> Anyone have a suggestion. It seems we HAVE to do it code.
>
> Thanks for any and all kind replies.
>
> Good Luck! Brian_RestonVA
Received on Mon Sep 14 1998 - 09:16:25 CDT