pdb_get_sql_database

Returns the name of the current database, if any.

Syntax

pdb_get_sql_database

Usage

  • When pdb_get_sql_database is invoked, it returns the name of the current database.

  • If the pdb_set_sql_database command has not been invoked to set the current database, it returns the default current database.

  • The current database is either:

    • The default current database, which is the primary database specified in the Replication Agent pds_database_name configuration parameter, or

    • The database specified in the command to which the Replication Agent instance is currently connected. (This is not valid for Oracle.)

  • To set or change the current database, use the pdb_set_sql_database command.

    Note: In Oracle, you cannot change the current database.

  • The pdb_get_sql_database command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.

Related reference
pdb_execute_sql
pdb_set_sql_database