Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help on calling stored procedures
In article <1998032723382001.SAA18800_at_ladder01.news.aol.com>, SteverR wrote:
Steve,
Assuming you have not mis-typed, the most likely cause for this error is not being able to see the stored procedure or package in question.
When you compile the Pro*C, are you connecting to the database as the owner of the package? If not, then a (public) synonym may be required to point to the package or you may need to GRANT EXECUTE on the package to the connecting user:
create public synonym PACKAGE_NAME for OWNER.PACKAGE_NAME; grant execute on PACKAGE_NAME to CONNECTING_USER;
regards
Neil Chandler
>Having trouble calling a stored procedure from Pro*C. I get an error stating
>"identifier package.procedure must be declared."
>
>I am following examples from the book but the code will not compile.
>
>Any suggestions?
Received on Tue Mar 31 1998 - 00:00:00 CST