Re: PL/SQL Packages

Your newshopper function is invalid/didn't compile. Issue select * from user_errors
to find out what the errors are.
The other errors are a result of the invalid function.

Hth,

Sybrand Bakker, Oracle DBA

SP <spant1_at_aol.com> schreef in berichtnieuws Bib05.904$Qf6.34547_at_nuq-read.news.verio.net...
> To my earlier posting:
> I found out the error message was due to the fact that I didn't end the
> package body and variable newcustid wasn't declared.
>
> I've another question though when I execute the function I got the
 following
> error messages:
>
> SQL> variable c refcursor
> SQL> exec :c := newshopper('tom','joe')
> BEGIN :c := newshopper('tom','joe'); END;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 13:
> PLS-00905: object SA.NEWSHOPPER is invalid
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> SQL> print c
> ERROR:
> ORA-24338: statement handle not executed
>
>
> SP2-0625: Error printing variable "c"
> I appreciate your response.
> SP
>
>
Received on Fri Jun 09 2000 - 00:00:00 CDT