dblink_ora_call() v10

The dblink_ora_call() function executes a non-SELECT statement on an Oracle database and returns a result set. The signature is:

dblink_ora_call(<conn_name>, <command>, <iterations>)

Where:

  • conn_name specifies the name of the link.

  • command specifies the text of the SQL statement that will be invoked on the Oracle server.

  • iterations specifies the number of times the statement is executed.

The function returns a SETOF record.