PL/SQL error 201
Date: 1995/11/01
Message-ID: <47907o$acd_at_pegasus.rutgers.edu>#1/1
I am having a problem compiling a PRO*C program which has embedded PL/SQL in it. The PL/SQL block calls a procedure which is part of a package in the database.
The package name is SAP_PROCS, and the procedure name is check_upd_frequency.
the PL/SQL block in the C program is
EXEC SQL EXECUTE
BEGIN
sap_procs.check_upd_frequency;
END;
END-EXEC;
I am getting the following error from the pre-compiler:
"PLS-00201 identifier sap_procs.check_upd_frequency must be declared".
Where do I declare it? I have granted execute privelage to PUBLIC on the package. I have followed the example in the PRO*C supplement to the T.
Any help appreciated.
Rob Hutchinson
robh_at_pegasus.rutgers.edu
Received on Wed Nov 01 1995 - 00:00:00 CET