CONNECT STRING

  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 Fri Sep 04 1998 - 11:58:02 CDT