Error while calling onr procedure from another procedure

Hi All,
I have completed one package coding. I am calling anothet procedure in one of my procedure of my package.
declare
.
.
.
package.get_pallet_details (var1_in,var_out,.....);
dbms_output.put_line(var_out);
There are lot of lines in between, and i m passing one in variable and 16 out varaibles here.
I have verified the datatypes and also number of arguments passed here.Everything is fine .
When i executed it as seprate block it si running fine.
But when i m calling in my procedure throwing the below error during compilation
491/6    PL/SQL: Statement ignored
491/6    PLS-00306: wrong number or types of arguments in call to
         'GET_PALLET_DETAILS'

Could anyone help on this issue?


srividhyapavaniAsked:
Who is Participating?
 
sdstuberCommented:
what is the declaration of intf_pkg.get_pallet_details?
0
 
sdstuberCommented:
please post the exact procedure specification and your invocation of it.

if you are invoking it with variables, post the declaration section that defines those variables
0
 
srividhyapavaniAuthor Commented:
Hi The below procedure i m running seperately
DECLARE
lic_no_i_in     VARCHAR2(30) := '1234567';
item_c_out     VARCHAR2(30);
item_desc_out  VARCHAR2(80);
vcp_q_out      VARCHAR2(30);
loc_c_out      VARCHAR2(30);
stat_c_item    VARCHAR2(30);
sz_c_item      VARCHAR2(30);
tctn_qty_out   NUMBER;
exp_rcpt_i_out VARCHAR2(30);
rcpt_i_out     VARCHAR2(30);
rein_ts_out   DATE;
rein_user_id   VARCHAR2(30);
put_ts_out     DATE;
put_user_id    VARCHAR2(30);
soo_code       VARCHAR2(30);
doc_no         VARCHAR2(30);
return_i_out number;
BEGIN
intf_pkg.get_pallet_details(lic_no_i_in ,
                               item_c_out    ,
                               item_desc_out ,
                               vcp_q_out    ,
                               loc_c_out     ,
                               stat_c_item  ,
                               sz_c_item    ,
                               tctn_qty_out ,
                               exp_rcpt_i_out,
                               rcpt_i_out   ,
                               rein_ts_out  ,
                               rein_user_id  ,
                               put_ts_out   ,
                               put_user_id  ,
                               soo_code    ,
                               doc_no      ,
                               return_i_out);
   DBMS_OUTPUT.PUT_LINE('Container status : '|| stat_c_item );
END;
And running fine. when i m calling this in my procedure excluding declare word , throwing the above error during compilation.
0
 
srividhyapavaniAuthor Commented:
i got it resolved.It a schema problem thank you for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.