Oracle Database Errors or Warnings from Error ORA-23348 to ORA-23356


ORA-23348: cannot replicate procedure string; only IN parameters supported
Cause: Trying to generate replication support for a package that has a procedure with OUT or IN OUT parameters.
Action: Remove the procedure from the package, or remove the OUT or IN OUT parameters from the procedure.
ORA-23349: cannot generate replication support for functions
Cause: Trying to generate replication support for a package that has a public function, or for a stand-alone function.
Action: Remove the public function from the package, or alter the function to be a procedure.

ORA-23350: maximum number of recursive calls exceeded
Cause: This usually occurs when trying to resolve conflicts in a table while concurrent updates to the same row create more conflicts.
Action: Re-execute the deferred transaction from DefError using dbms_defer_sys.execute_error
ORA-23351: parameter datatype string for procedure string not supported
Cause: The procedure has a parameter whose datatype is not supported by repcat.
Action: Remove the parameter from the procedure, or alter the parameter to have one of the supported datatypes.
ORA-23352: duplicate destination for deferred transaction
Cause: A duplicate destination was specified for a deferred transaction either in a call or an earlier dbms_defer.transaction call or a dbms_defer_sys.add_default_dest call.
Action: Remove the duplicate entry

ORA-23353: deferred RPC queue has entries for object group “string”.”string”
Cause: The requested action cannot be performed until the queue is empty for the given object group
Action: Use dbms_defer_sys.execute or dbms_defer_sys.delete_tran to empty the queue.
ORA-23354: deferred RPC execution disabled for “string” with “string”
Cause: Deferred RPC can not be executed at the destination with the specified catchup value because their propogation has been disabled.
Action: Enable deferred RPC execution with the dbms_defer_sys.set_disabled call.
ORA-23355: object string.string does not exist or is invalid at master site
Cause: The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object at the master site, or the object does not exist as a replicated object with the appropriate status.
Action: Ensure the object is valid in the master database, and is visible to the user, and, if appropriate, is a valid object in all_repobject.
ORA-23356: masterdef recognizes a master which does not recognize the masterdef
Cause: Possibly drop_master_repgroup was run at a master site but remove_master_databases was not run at master definition site for that master.

Above are list of Oracle Database Errors or Warnings from Error ORA-23348 to ORA-23356 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *