My Oracle Support Banner

Running Domainman.Transmission_Purge with just Age In Days Parameter Errors (Doc ID 1119506.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Nov-2013***

Symptoms

On OTM Version 6.0.4, When attempting to run the procedure domainman.transmission_purge with a single argument, the following error occurs.
However the procedure can be run by providing three arguments as against one
ERROR
-----------------------
BEGIN domainman.transmission_purge(900); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00307: too many declarations of 'TRANSMISSION_PURGE' match this call
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Connect to an OTM database
2. run the procedure with a single argument as follows
exec domainman.transmission_purge(900);
3. See the error appear immediately

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.