Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dblink question....
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