CODEWITHSUNDEEP
oracle-databasestored-proceduresplsql
triplus
triplus

Reputation: 91

How to call a procedure from a package?

I would like to call a procedure from a package:

exec TEST_Procedure.TEST_Procedure_PR(Parameter1, Parameter2, Parameter3, Parameter4, Parameter5);

The Parameters are all quoted and I have 5 IN Parameters and 1 OUT (Ref Cursor).

However when I call the procedure in the package directly I get my values. If I call the procedure from the cmd line with SQL I get the error:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TEST_Procedure_PR'

What am I doing wrong?

Upvotes: 0

Views: 313

Answers (1)

Bob Jarvis - Слава Україні
Bob Jarvis - Слава Україні

Reputation: 50017

In your package just code the procedure call without the EXEC statement, which is only required in SQL*Plus. For example,

CREATE PACKAGE BODY YOUR_PACKAGE AS

PROCEDURE SOME_PROCEDURE IS
BEGIN
   TEST_Procedure.TEST_Procedure_PR(Parameter1,
                                    Parameter2,
                                    Parameter3,
                                    Parameter4,
                                    Parameter5);
END SOME_PROCEDURE;

END YOUR_PACKAGE;

Best of luck.

Upvotes: 1

Related Questions