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: database link vrs. remote connect - a question

Re: database link vrs. remote connect - a question

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 11 Jul 2001 08:24:47 +0200
Message-ID: <1kS27.4440$tD1.540749@news3.oke.nextra.no>

Hi!

I'm not able to try it either, but the doc( O8.1.6/Windows 2000) says that: "Restrictions on Cursor variables:
....
Remote subprograms on a remote _server_ cannot accept values of cursor variables. Therefore you cannot use RPCs to pass cursor variables from one server to another
 ...."

Frank

>
> A stored procedure can return a REF CURSOR.
>
> Though I must confess I've not tried it across a database link I can't
 imagine
> why it wouldn't work.
>
> Daniel A. Morgan
>
Received on Wed Jul 11 2001 - 01:24:47 CDT

Original text of this message

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