Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: dbms_sql.parse does not allow remote conn via dblink

Re: dbms_sql.parse does not allow remote conn via dblink

From: Marc <E.Mail_at_address.com>
Date: 2000/05/17
Message-ID: <8ftb83$mq2$1@vkhdsu24.hda.hydro.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US