Solved

Error while calling onr procedure from another procedure

Posted on 2010-11-14
4
511 Views
Last Modified: 2013-12-19
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?


0
Comment
Question by:srividhyapavani
  • 2
  • 2
4 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 34131304
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
 

Author Comment

by:srividhyapavani
ID: 34133409
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
 
LVL 73

Accepted Solution

by:
sdstuber earned 125 total points
ID: 34135323
what is the declaration of intf_pkg.get_pallet_details?
0
 

Author Closing Comment

by:srividhyapavani
ID: 34239568
i got it resolved.It a schema problem thank you for your help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question