Dd link parameter

[fraze]

I'm trying to pass in the first part of a db link with a parameter in a procedure but cant seem to get the syntax right - can anyone please help?


PROCEDURE INVALID_OBJECTS1 (p_dbsid varchar)
IS
cursor c_total_inv_obj is
select owner,object_name, object_type
from dba_objects@p_dbsid||'.world'
where status = 'INVALID'
and object_type in ('PACKAGE BODY','PACKAGE','FUNCTION',
'PROCEDURE','TRIGGER','VIEW','QUEUE');

[marist89]

you can't do it throught straight pl/sql like that. You have to use dynamic sql.

[raghud]

As Jeff mentioned use execute immediate

v_sql = 'select .... oracle' + '.world'

execute immediate(v_sql)

[gandolf989]

You should take a look at ref cursors.