Stored Procedures errors when calling...

...but not when compiling.

I am using Oracle 8.1.6.

I have created a stored procedure to return one value.

CREATE OR REPLACE PROCEDURE "CODE81"."GETREMAININGMYRATE" (MYRATE OUT NUMBER)
as
  asofdate date;

begin
  select LABOR_ASOF INTO asofdate FROM LAB_ASOF_DATE;  

  MYRATE := ((158800/52)*to_char(to_date('30-SEP-03','DD-MON-YY')-asofdate)/7);

end GETREMAININGMYRATE;

This compiles with no errors. And according to a couple of Oracle books the syntax is correct.

I am trying to test it using Oracle SQL *Plus.

I am typeing this at the SQL> prompt...

execute getremainingmyrate;

and this is the result...

BEGIN getremainingmyrate;

      *
ERROR at line 1:

ORA-06550: line 1, column 
PLS-00306: wrong number or
ORA-06550: line 1, column 

*

ERROR at line 1:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'GETREMAININGMYRATE' What am I doing wrong?????

TIA
Jeff Reed Received on Fri Jan 24 2003 - 21:49:07 CET