Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: dbms_sql.parse does not allow remote conn via dblink
And if you need complete flexibility, you can call dbms_sql_at_dblink (or another remote stored procedure) by means of local dbms_sql ;-)
Marc
Marc wrote in message <8ftaue$mki$1_at_vkhdsu24.hda.hydro.com>...
>Possible solution: use dbms_sql_at_dblink (i.e. use remote dbms_sql).
>
>Marc
>
>jawa wrote in message <8frv2v$be9$1_at_spsnews.sps.mot.com>...
>>Package dbms_sql.parse does not allow object mods (ie - alter table) to a
>>remote database via a dblink. Does anyone know a quick way to accomplish
>>this remotely in PL/SQL? Thanks in advance!
>>
>>--
>>Jim Wadas
>>Information Technology Solutions and Services (ITSS)
>>Motorola Systems Solutions Group (SSG)
>>Scottsdale, AZ 85257
>>phone (480) 441-8196
>>Jim.Wadas_at_motorola.com
>>
>>
>
>
Received on Wed May 17 2000 - 00:00:00 CDT
![]() |
![]() |