Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Error while calling onr procedure from another procedure

Posted on 2010-11-14
4
Medium Priority
?
521 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 74

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 74

Accepted Solution

by:
sdstuber earned 250 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month12 days, 9 hours left to enroll

578 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