REMOTE_EXECUTE_IMMEDIATE

REMOTE_EXECUTE_IMMEDIATE

The REMOTE_EXECUTE_IMMEDIATE procedure executes the input SQL statement on the remote server through the database link. Excluding the SELECT statement, DML, DDL and DCL statements are executable. SQL statements including parameter markers cannot be executed with this procedure.

Syntax

REMOTE_EXECUTE_IMMEDIATE (
    dblink_name     IN VARCHAR,
    statement_text  IN VARCHAR );

Parameters

Name	In/Output	Data Type	Description
dblink_name	Input	VARCHAR	The name of the database link object
statement_text	Input	VARCHAR	The SQL statement to be executed on the remote server

Return Value

Because it is a procedure, there is no return value.

Example

<Query 1> Create table remote_t in the remote server, pointed to by link1, and after inserting a record, delete the table.

EXEC REMOTE_EXECUTE_IMMEDIATE( 'link1', 'create table remote_t( c1 integer )' ); 
EXEC REMOTE_EXECUTE_IMMEDIATE( 'link1', 'insert into remote_t values (10)' ); 
EXEC REMOTE_EXECUTE_IMMEDIATE( 'link1', 'insert into remote_t values (20)' ); 
EXEC REMOTE_EXECUTE_IMMEDIATE( 'link1', 'insert into remote_t values (30)' ); 
EXEC REMOTE_EXECUTE_IMMEDIATE( 'link1', 'drop table remote_t' );