-
hi all
I want to create a dblink within a pl/sql block (like procedure or function), i have Oracle 8i
try
declare
execute immediate 'create database link redcou connect to system identified by xxx using '':cadena''' using v_cadena;
end;
and send me the next error in the execution time
SQL> execute bases.crea_dblink;
BEGIN bases.crea_dblink; END;
*
ERROR at line 1:
ORA-06546: DDL statement is executed in an illegal context
how can i create a db link other wise????
thanks for all
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|