Home » SQL & PL/SQL » SQL & PL/SQL » PLSQL Procedure Error (Oracle 9i)
PLSQL Procedure Error [message #325046] Wed, 04 June 2008 22:11 Go to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Hi,
I have a package which is having the PLSQL Table as a parameter. Now i created a procedure, inside that i build the PLSQL Table and passing to that Package. but its giving me

PLS-00306: wrong number or types of arguments in call
to 'INSERT_RECEIPT'


actually all the Parameters and the Data types are all same. but still i m getting this problem...

pls any one help me...its urgent...


My PLSQL Structure..



TYPE REC_REF_DTL IS RECORD (
OPERATING_FACILITY_ID VARCHAR2(6),
DOC_TYPE_CODE VARCHAR2(18),
DOC_NUMBER NUMBER(Cool,
DOC_DATE DATE,
POST_MONTH NUMBER(2),
POST_YEAR NUMBER(4),
PATIENT_ID VARCHAR2(60),
DOC_AMT NUMBER,
SLMT_TYPE_CODE VARCHAR2(6),
SLMT_DOC_REF_DESC VARCHAR2(60),
SLMT_DOC_REF_DATE DATE,
SLMT_DOC_REMARKS VARCHAR2(90),
APPROVAL_REF_NO VARCHAR2(90),
BANK_RECON_REF VARCHAR2(30),
CANCELLED_IND VARCHAR2(3),
POSTED_IND VARCHAR2(3),
CASH_SLMT_FLAG VARCHAR2(3),
BOUNCED_YN VARCHAR2(3),
BOUNCED_COUNT NUMBER,
BOUNCED_DATE DATE,
BILLED_YN VARCHAR2(3),
CANCEL_REASON VARCHAR2(150),
CASH_CTRL_DOC_TYPE_CODE VARCHAR2(18),
CASH_CTRL_DOC_NUMBER NUMBER,
CASH_CTRL_DOC_DATE DATE,
UNPOSTED_REASON VARCHAR2(150),
CONSOLIDATED_RECEIPT_YN VARCHAR2(3),
CC_BATCH_NO VARCHAR2(24),
CC_SALE_DRAFT_NO VARCHAR2(60),
CC_SWAPPED_YN VARCHAR2(3),
BANK_IN_BATCH_DOC_TYPE VARCHAR2(18),
BANK_IN_BATCH_DOC_NO NUMBER(Cool,
BANK_IN_BATCH_DOC_DATE DATE,
BANK_IN_DOC_NO VARCHAR2(60),
BANK_IN_DATE DATE,
REPL_CHQ_YN VARCHAR2(3),
REPL_CHQ_DOC_TYPE_CODE VARCHAR2(18),
REPL_CHQ_DOC_NUM NUMBER(Cool,
REPL_CHQ_DOC_DATE DATE,
ADDED_BY_ID VARCHAR2(90),
ADDED_DATE DATE,
MODIFIED_BY_ID VARCHAR2(90),
MODIFIED_DATE DATE,
ADDED_AT_WS_NO VARCHAR2(90),
ADDED_FACILITY_ID VARCHAR2(6),
MODIFIED_AT_WS_NO VARCHAR2(90),
MODIFIED_FACILITY_ID VARCHAR2(6),
BANK_CODE VARCHAR2(18),
BANK_BRANCH VARCHAR2(180),
DF_INTERFACED_YN VARCHAR2(3),
DF_INTERFACED_DATE DATE,
CASH_AMT_GIVEN NUMBER,
CASH_AMT_RETURNED NUMBER,
DOC_SRNO NUMBER(4),
PAYER_NAME VARCHAR2(120),
RCPT_RFND_ID_NO VARCHAR2(90),
NOMINEE_NAME VARCHAR2(120),
REF_DEP_DOC_TYPE_CODE VARCHAR2(18),
REF_DEP_DOC_NUMBER NUMBER(Cool,
REF_DEP_DOC_SRNO NUMBER(2));


TYPE RECEIPT_DTL is TABLE OF REC_REF_DTL
INDEX BY BINARY_INTEGER;
P_BL_RECEIPT_REFUND_DTL_TEMP RECEIPT_DTL;

and i m calling the package liks this,

BL_INSERT_DEPOSIT.INSERT_RECEIPT
(P_BL_RECEIPT_REFUND_DTL_TEMP,P_USER_ID,P_FACILITY_ID,
P_LANGUAGE_ID,P_WS_NO,P_CASH_COUNTER,P_SHIFT_ID,P_CC_COUNT,
P_CALLING_FUNCTION_ID,P_ND_SESSION_ID,P_ND_PGM_DATE,
P_DOC_TYPE_CODE,P_DOC_NUMBER,P_ERROR_LEVEL,
P_SYS_MESSAGE_ID,P_ERROR_TEXT);

the First Parameter is PLSQL Table others are Ordinary.

Regards,
Kalyan
Re: PLSQL Procedure Error [message #325048 is a reply to message #325046] Wed, 04 June 2008 22:15 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above.

If you expect worthwhile answers, you need to provide us details in order to reproduce your problem.
Previous Topic: Sql query
Next Topic: Script for Table names and row counts
Goto Forum:
  


Current Time: Thu Dec 08 16:33:19 CST 2016

Total time taken to generate the page: 0.10234 seconds