Re: Dynamic SQL and Database Links

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Jul 1999 20:33:39 +0100
Message-ID: <931981103.1667.0.nnrp-02.9e984b29@news.demon.co.uk>

The 2000 character limit may not be the problem it was - I am assuming you are
thinking of using the dbms_sql package
and running from PL/SQL.

There is a variant of the original dbms_sql.parse statement which takes an array of varchar2(255) as the input. (An example of using it appears on my website under

'PL/SQL topics' -> dbms_sql, a little wrapper for dynamic SQL

As for using the database link, that should be no problem. Most of the operations I do when working as a 'remote DBA' involve running PL/SQL scripts that generate code to address databases through dynamically derived database links.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Wed Jul 14 1999 - 14:33:39 CDT