Returns a list of input parameters for procedures in the current database at the primary data server.
This command is available only for Oracle and Microsoft
SQL Server.
pdb_get_procedure_parms [ownername, procname [, paramname]]
The user name of the owner of the procedure specified in procname. This option can be delimited with quote characters to specify character case.
The name of the procedure in the current database for which information is returned. This option can be delimited with quote characters to specify character case.
The name of the input parameter for which information is returned. This option can be delimited with quote characters to specify character case.
pdb_get_procedure_parms
This command returns a list of all of the input parameters for all of the procedures in the current database.
pdb_get_procedure_parms bob, sp_foo
This command returns a list of all of the input parameters for the procedure named sp_foo, owned by the user “bob” in the current database.
pdb_get_procedure_parms bob, sp_foo, foo_count
This command returns information about the input parameter foo_count for the procedure sp_foo, owned by the user “bob” in the current database.
(For Oracle and Microsoft SQL Server)
Results from these commands are from the Replication Agent System
database (RASD).
(For UDB) Results from these commands are directly
from the primary database.
When pdb_get_procedure_parms is invoked with no option, it returns a result set that lists all of the input parameters for all the procedures in the current database.
When pdb_get_procedure_parms is invoked with the ownername and procname options, it returns a result set that lists all of the input parameters for the specified procedure with the specified owner in the current database.
When pdb_get_procedure_parms is invoked with the ownername, procname, and paramname options, it returns a result set with information about the specified input parameter for the specified procedure with the specified owner in the current database.
The pdb_get_procedure_parms 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_procedure_parms command returns 0 rows if the specified procedure (with the specified owner) does not exist in the current database.
The pdb_get_procedure_parms command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.
pdb_get_columns, pdb_get_databases, pdb_get_primary_keys, pdb_get_procedures, pdb_get_tables
