Re: Running SQLs betweem RAC Instance

From: Steve Howard <>
Date: Thu, 3 Jan 2008 13:48:32 -0800 (PST)
Message-ID: <>

On Jan 3, 3:38 pm, ibodogan <> wrote:

>         FOR l_rec3 IN (SELECT plan_table_output
>                         FROM table


It sounds like this is your issue. Since you can't pass parameters to a remote object type (which display_cursor) returns, a database link is out. You could use a java stored procedure in the database to do this (URL connects directly to instance x), but this sounds like a ton of work relative to what the database control does for free :) Good learning exercise, though.


Steve Received on Thu Jan 03 2008 - 15:48:32 CST

Original text of this message