Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database link vrs. remote connect - a question
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