Oracle Package Errors
Clash Royale CLAN TAG#URR8PPP
Oracle Package Errors
I am running a jrxml file that calls an oracle package and am getting this error:
java.sql.SQLException:
ORA-06550: line 1, column 14: PLS-00302: component 'EXAMPLE_PACK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.
This package however, has grant of Execute and debug.
GRANT EXECUTE,DEBUG ON EXAMPLE_PACK TO USER;
Edit
Spec ----
CREATE OR REPLACE PACKAGE tbaadm.fin_atmgl_pack
AS
PROCEDURE fin_atmgl_proc (inp_str IN VARCHAR2,
out_retcode OUT NUMBER,
out_rec OUT VARCHAR2);
END fin_atmgl_pack;
/
Hi Joseph. To get a better responses, you should probably tag your question better. Some tags come to my mind - plsql and jasper-reports, but I am not sure, so edit your tags as you see fit.
– Piro
Aug 6 at 10:33
Thank you @Piro.
– Joseph
Aug 6 at 11:05
Show us the code snippet of both spec and body.
– user75ponic
Aug 6 at 11:06
Spec ----CREATE OR REPLACE PACKAGE TBAADM.FIN_ATMGL_PACK AS PROCEDURE FIN_ATMGL_PROC ( inp_str IN VARCHAR2, out_retCode OUT NUMBER, out_rec OUT VARCHAR2); END FIN_ATMGL_PACK; /
– Joseph
Aug 6 at 14:55
1 Answer
1
i am thinking
EXAMPLE_PACK might be declared in package body but not declared package spec.
Example_pack has SCHEMA.EXAMPLE_PACK declared on both the spec and body of the package. It also has it's grant to public. yet i still get the same error anytime i run it from my frontend
– Joseph
Aug 6 at 11:02
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Does EXAMPLE_PACK have a public synonym? Otherwise you would have to put the scheme name in front of it like SCHEME.EXAMPLE_PACK
– Moh-Aw
Aug 6 at 9:22