I'm having problems running execute immediate from a procedure. Basically I'm trying to create a database link from information stored in a table (list_of_tables) - using 9.2.0.5
The error I'm getting isCode:select * into v_lod from list_of_databases where lod_sid = p_dbsid; execute immediate 'create database link '||v_lod.lod_sid||'.world connect to '||v_lod.lod_username|| ' identified by '||v_lod.lod_password||' using '||chr(39)||v_lod.lod_prmy_tns||chr(39)||';';
ERROR at line 1:
ORA-00911: invalid character
ORA-06512: at "DBACHECK.FRAZE_TEST", line 35
ORA-06512: at line 1
Any help appreciated




Reply With Quote