database link

[guedi]

How can I use the SQL command

create database link REMOTE_CONNECT
connect to (database) identified by (password)
using '(database_name)';

in a program window

 

[Marco Kalter]

Do you want the program unit to create a database link at runtime? In that case you can use the EXECUTE IMMEDIATE statement, followed by the DDL command:

create or replace procedure create_db_link as
begin
  execute immediate 'create database link mydblink';
end;