Solved

Error while calling onr procedure from another procedure

Posted on 2010-11-14
4
512 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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
database upgrade 8 117
Create Index on a Materialized View 5 36
Oracle collections 15 29
Create file system directory from Oracle 10g 4 25
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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

821 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