Re: Running SQLs betweem RAC Instance
Date: Thu, 3 Jan 2008 13:48:32 -0800 (PST)
On Jan 3, 3:38 pm, ibodogan <idogan_t..._at_yahoo.com> wrote:
> FOR l_rec3 IN (SELECT plan_table_output > FROM table
> (DBMS_XPLAN.DISPLAY_CURSOR(l_rec.sql_id)) ) LOOP
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