Hi,
Hope you can help, if you can i will be very grateful...
My problems is...
I have a package that is using an oracle type, cut out below
TYPE NAME AS TABLE OF OBJECT.TYPE
OBJECT.TYPE AS OBJECT
( UNIQUE_PARCEL_ID VARCHAR2(16) ACTION_CODE VARCHAR2(2) STATUS_DATE DATE REASON_CODE VARCHAR2(3) CONTAINER_ID VARCHAR2(16) MIGRATION_SET_ID NUMBER(3) ROUTE_CODE VARCHAR2(2))
The package is...
PROCEDURE main(p_calling_system IN VARCHAR2, p_calling_service IN VARCHAR2, p_unique_id IN VARCHAR2, p_user_id IN VARCHAR2, p_location_id IN VARCHAR2, p_van_reg IN VARCHAR2, p_depot_code IN VARCHAR2, hht_tracking_detail IN T_TAB_HHT_TRACKING_DETAIL, p_return_code OUT NUMBER, p_return_message OUT VARCHAR2);END;
My problem is i dont know how to call the procedure while mapping to hht_tracking_detail...
This is what i have...
OraParam.CollectionType =
OraParam.DbType =
OraParam.Value =
OraParam.Direction =
OraParam.Size = 8000;
OraParam.ParameterName =
OraParam.ArrayBindStatus = new OracleParameterStatus[7]
{ OracleParameterStatus.Success,
OracleParameterStatus.Success,
OracleParameterStatus.Success};*/
oCmd.Parameters.Add(OraParam);
the error is saying i have the incorrect params