Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Error while calling onr procedure from another procedure

Posted on 2010-11-14
4
Medium Priority
?
518 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

609 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