Re: Communication between Bind and Substitution variables in SQLPLUS?

In article <4v7nic$7jr_at_lal.interserv.com>,

   wvc_at_interserv.com (Bill Valentine-Cooper) wrote:
>I've worked around this for the moment by (blush) prompting the user
>with the bind variables and asking them to type exactly what they see
>right back into substitution variables. You can bet that I've got a
>disclaimer on that code!

you therefore have one-half of the solution. instead of pronpting the user, put that sql in a blah.sql file, and use "&1" wherever you now prompt. now blah.sql takes a parameter.

generate sql to select the stuff you need from the remote database. the result of the select will be calls to your blah.sql file (above), with the synonym definition concatenated as the parameter. spool this to a file, then execute it. the sql looks like: select 'start blah.sql ' || synonym_stuff

this a crude way to create recursive sql.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.