Re: Executing Dynamic SQL

Execute is a sqlplus shortcut.
You need to use
dbms_sql.parse(cur_handle, 'begin dbms_space_x.unused_space(parameter_list); end')
Please note procedure_name_at_remote_database is valid syntax. You don't need the public synonym.

Hth,

--
Sybrand Bakker, Oracle DBA
<miaemp_at_my-deja.com> wrote in message news:84fsvh$lvk$1_at_nnrp1.deja.com...
> I am trying to execute a stored package using dynamic sql. Can this be
> done? I am getting an ora-900 error, invalid sql statement. The sql
> statement I am parsing is 'execute dbms_space_x.unused_space(parameter
> list)'. dbms_space_x is a public synonym pointing to a remote
> database's dbms_space where x is the database name. All of the
> parameters are bound. Is my statement correct? Normally I would have
> mad a call to dbms_space package in an anonymous pl/sql block, but,
> this has to be dynamic as there are mulitple databases being tracked.
> Any thoughts?
>
> TIA
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 30 1999 - 10:19:46 CST