Oracle version 10.2.0.3.0
I am writing a PL/SQL stored procedure that accepts a parameter of type INTERVAL YEAR TO MONTH. For example...
CREATE OR REPLACE PROCEDURE INTERVAL_TEST ( pin_Interval IN INTERVAL YEAR TO MONTH )
Problem with the above is that if I try to call it with pin_Interval = '100-00', I get the following error...
ORA-01873: the leading precision of the interval is too small
... but I am not able to specify the precision of the YEAR component in the stored procedure defintion as follows...
CREATE OR REPLACE PROCEDURE INTERVAL_TEST ( pin_Interval IN INTERVAL YEAR(4) TO MONTH )
... this results in...
PLS-00103: Encountered the symbol "(" when expecting one of the following: to
Try as I might, I can't create a stored procedure that will take in an INTERVAL YEAR TO MONTH with greater than 2 precision on the year.
Hopefully I am just doing something stupid, and this is not a limitation of PL/SQL.
Any help is appreciated.