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