(Oracle and Microsoft SQL Server only) Returns a list of input parameters for procedures in the current database at the primary data server.
pdb_get_procedure_parms [ownername, procname [, paramname]]
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.
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 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.
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.