Hi everybody,
I’m trying to call a stored proc but FUNCTION, not procedure, and i’m getting two type of error messages:
1- When i execute my adapter wich is a StoredProcedureWithSignature, i get this message:
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Quattro_Int_BMP.Config:Autre_Test.
[ADA.1.314] Cannot set data for the input field “P_EFFECTIVE_DATE”
Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
2- when i use a flow with a step formatting the date field with this format(yyyy-MM-dd hh:mm:ss.S), and calling my adapter after i get this message:
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Quattro_Int_BMP.Config:Autre_Test.
[ADA.1.316] Cannot execute the SQL statement “{?= call BMPDBAB.CONNECTEUR.CB_TRAITEMENT_BMP( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}”. "
(63000/3115) ORA-03115: unsupported network datatype or representation
"
ORA-03115: unsupported network datatype or representation.
My function is as follow:
FUNCTION CB_traitement_BMP
(p_trans_id IN CB_HISTORIQUE.TRANS_ID%TYPE,
p_trans_type IN CB_HISTORIQUE.TRANS_TYPE%TYPE,
p_phone_number IN OUT BMP_MOBILE_CLIENTS.PHONE_NUMBER%TYPE,
p_imsi IN BMP_MOBILE_CLIENTS.IMSI%TYPE,
p_subscription_id IN BMP_MOBILE_CLIENTS.SUBSCRIPTION_ID%TYPE,
p_serviceid_type IN BMP_MOBILE_CLIENTS.SERVICEID_TYPE%TYPE,
p_effective_date IN BMP_MOBILE_CLIENTS.ACTIVE_DATE%TYPE,
p_account_no IN BMP_MOBILE_CLIENTS.ACCOUNT_NO%TYPE,
p_franchise_code IN BMP_MOBILE_CLIENTS.FRANCHISE_CODE%TYPE,
p_bill_period IN BMP_MOBILE_CLIENTS.BILL_PERIOD%TYPE,
p_code_erreur OUT NUMBER,
p_desc_erreur OUT VARCHAR2,
p_resp OUT VARCHAR2 ) RETURN NUMBER;
Just a notice, when i use almost the same body of function but without output fields and replacing the key word FUNCTION by PROCEDURE, my adapter works
Thanks in advance for your help.