pdb_get_procedures

Description

Returns a list of procedures in the current database at the primary data server.

Syntax

pdb_get_procedures [ownername, procname]

Parameters

Examples

Example 1

pdb_get_procedures

This command returns a list of all of the procedures in the current database.

Example 2

pdb_get_procedures bob, sp_foo

This command returns information about the procedure named sp_foo, owned by the user “bob” in the current database.

Usage

• When pdb_get_procedures is invoked with no option, it returns a result set that lists all of the procedures in the current database.

• When pdb_get_procedures is invoked with the ownername and procname options, it returns a result set with information about the specified procedure with the specified owner in the current database.

• The pdb_get_procedures command accepts the % wildcard character in both the ownername and procname options.

• 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 pdb_set_sql_database 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.

  In Oracle, you cannot change the current database.

• To find the name of the current database, use the pdb_get_sql_database command.

• The pdb_get_procedures command returns 0 rows if the specified procedure (with the specified owner) does not exist in the current database.

• The pdb_get_procedures command is valid when the Replication Agent instance is in either Admin or Replicating state.

See also