Re: Dynamic SQL and Database Links

Wasn't that a 32000 character limit, not 2000?

• Alton

Jonathan Lewis wrote:

> 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:58:30 CDT