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

Home -> Community -> Usenet -> c.d.o.server -> Re: dblink question....

Re: dblink question....

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: 2000/08/12
Message-ID: <3994F7B5.2C4B1927@0800-einwahl.de>#1/1

gdas wrote:
>

 ...
> >
> >'alter session close database link link_name ;'
>
> Both databases are 8.1.5. The above statement will work very
> well for me since already all of the DML we do is inside
> procedures.
>
> PL/SQL doesn't seem to like the alter session statement inside a
> procedure, so placed it inside an EXECUTE IMMEDIATE call. Is
> this the correct approach?
>

Yes, it is.

Martin Received on Sat Aug 12 2000 - 00:00:00 CDT

Original text of this message

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