Re: Stored Procedures errors when calling...

Try supplying a parameter.

"Jeff Reed" <thebigvalbosky_at_hotmail.com> wrote in message news:efc0dbf9.0301241249.4bbcc426_at_posting.google.com...
> ...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
> PL/SQL: Statement ignored
>
>
>
> Now, I ve tried using the call command instead of execute and this is
> what I get...
> SQL> call getremainingmyrate;
> call getremainingmyrate
> *
> ERROR at line 1:
> ORA-06576: not a valid function or procedure name
>
> I also tried...
> SQL> call getremainingmyrate();
> call getremainingmyrate()
> *
> 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 - 23:08:15 CET