Home » Developer & Programmer » Precompilers, OCI & OCCI » Call Stored procedure with input variable as object type in pro *c (Oracel 10 g)
Call Stored procedure with input variable as object type in pro *c [message #565296] Mon, 03 September 2012 04:27
gajanansp
Messages: 1
Registered: September 2012
Location: India
Junior Member
While calling stored procedure i am getting following error

PLS-S-00306, wrong number or types of arguments in call to PR_PROCESS_BASKET

specifications of package are as follow
  PROCEDURE PR_PROCESS_BASKET(PI1     IN NUMBER,
                              PI2        IN VARCHAR2,
                              PI3          IN VARCHAR2,
                              PI4           IN VARCHAR2,
                              PI5     IN DATE,
                              PI_6 IN VARCHAR2,
                              PI7   IN NUMBER,
                              PI_8         IN VARCHAR2,
                              PI_9           IN VARCHAR2,
                              PI_11   IN VARCHAR2,
                              PI_12    IN NUMBER,
                              PI_13         IN VARCHAR2,
                              PI_14            IN VARCHAR2,
                              PI_15          IN VARCHAR2,
                             [b]PI_dtsl      IN BASKET_RECORD_ARRAY,[/b]
                              PI_17         IN VARCHAR2,
                              PO_18           OUT VARCHAR2,
                              PO_19             OUT VARCHAR2);


I am getting error for BasketRecordArray input.

definition of BASKET_RECORD_ARRAY is
CREATE OR REPLACE TYPE "TYPE_BASKET_RECORD"                                                                                                                                                                                                                                                                                                     AS OBJECT
(
EXCH_ID   VARCHAR2(6),
SEQ_NO    NUMBER(2),
SECID     VARCHAR2(30),
QUANTITY  NUMBER(20),
VAL       NUMBER(20,5),
ACTION    VARCHAR2(1)
)



Using ott i have created OCI structure of the same and included in my proc application.
I have provided INTYPE as file generated by ott.
I have declared pointer of OCI structure and passed it to stored procedure .
But still I am getting the same error at the time of proc pre compilation.
i.e. proc iname= "filename" oname..........

Previous Topic: sqladt is initialized twice.
Next Topic: Keep getting ORA-22275 from extproc
Goto Forum:
  


Current Time: Thu Aug 28 19:03:16 CDT 2014

Total time taken to generate the page: 0.17138 seconds