cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC error while connecting to store procedure

praveenreddy_bk
Participant
0 Kudos

Hi Folks,

I have created the structure for JDBC receiver. Connecting to ORACLE databse10g. I am getiing below errorwhile excuting the proecedure

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'GetUmlerEquipDetails' (structure 'Statement'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'GETUMLEREQUIPDETAILS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Below is the structure

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_SADBUMLER_RECEIVE xmlns:ns0="urn:cpr.ca:pi:Umler:Aif"><Statement><GetUmlerEquipDetails action="EXECUTE" table="EDRAPP.EDR_EQUIP_DETAIL.GETUMLEREQUIPDETAILS"><P_VINMARKCD isInput="true" type="VARCHAR">ITTX  </P_VINMARKCD><P_VINEQPUNNBR isInput="true" type="VARCHAR">0000942040</P_VINEQPUNNBR><P_VOUTMARKCD isOutput="true" type="VARCHAR"></P_VOUTMARKCD><P_VOUTEQPUNNBR isOutput="true" type="VARCHAR"></P_VOUTEQPUNNBR><P_VOUTAAR_CAR_TYPE_CD isOutput="true" type="VARCHAR"></P_VOUTAAR_CAR_TYPE_CD><P_VOUTOTSD_LENGTH_QTY isOutput="true" type="VARCHAR"></P_VOUTOTSD_LENGTH_QTY><P_VOUTLESSEE_MARK_CD isOutput="true" type="VARCHAR"></P_VOUTLESSEE_MARK_CD><P_VOUTACTUAL_CPCTY_QTY isOutput="true" type="INTEGER"></P_VOUTACTUAL_CPCTY_QTY><P_VOUTCPCTY_UNIT_MSR_CD isOutput="true" type="VARCHAR"></P_VOUTCPCTY_UNIT_MSR_CD></GetUmlerEquipDetails></Statement></ns0:MT_SADBUMLER_RECEIVE>

Thanks in Advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

rohini_potham3
Explorer
0 Kudos

Hi Praveen,

Please check that your receiver Stored procedure structure is same as the SP structure in database. Please specify the correct types for each field. While creating data type, specify each field as xsd:string. For attribute "type" under each field, please specify the corresponding type "VARCHAR"/ "INTEGER" / "DATE" which are generally used.

Please ask your DB guy to provide one record from SP for testing  purpose so that you can validate correctly.

Note:If you have any date fields, use YYYY-MM-DD format to avoid any exceptions.

Regards,

Rohini.

former_member189440
Participant
0 Kudos

Hi ,

Please declare the table/sp name as "GETUMLEREQUIPDETAILS" just remove the this name from the xml EDRAPP.EDR_EQUIP_DETAIL. and try once.,

and your xml should be like this.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_SADBUMLER_RECEIVE xmlns:ns0="urn:cpr.ca:pi:Umler:Aif"><Statement><GetUmlerEquipDetails action="EXECUTE" table="GETUMLEREQUIPDETAILS"><P_VINMARKCD isInput="true" type="VARCHAR">ITTX  </P_VINMARKCD><P_VINEQPUNNBR isInput="true" type="VARCHAR">0000942040</P_VINEQPUNNBR><P_VOUTMARKCD isOutput="true" type="VARCHAR"></P_VOUTMARKCD><P_VOUTEQPUNNBR isOutput="true" type="VARCHAR"></P_VOUTEQPUNNBR><P_VOUTAAR_CAR_TYPE_CD isOutput="true" type="VARCHAR"></P_VOUTAAR_CAR_TYPE_CD><P_VOUTOTSD_LENGTH_QTY isOutput="true" type="VARCHAR"></P_VOUTOTSD_LENGTH_QTY><P_VOUTLESSEE_MARK_CD isOutput="true" type="VARCHAR"></P_VOUTLESSEE_MARK_CD><P_VOUTACTUAL_CPCTY_QTY isOutput="true" type="INTEGER"></P_VOUTACTUAL_CPCTY_QTY><P_VOUTCPCTY_UNIT_MSR_CD isOutput="true" type="VARCHAR"></P_VOUTCPCTY_UNIT_MSR_CD></GetUmlerEquipDetails></Statement></ns0:MT_SADBUMLER_RECEIVE>

Thanks & Regards

Arun..

baskar_gopalakrishnan2
Active Contributor
0 Kudos

check with DBA and specify the exact SP name.  See any schema you need to reference the SP. 

ambrish_mishra
Active Contributor
0 Kudos

Hi Praveen,

Few suggestions:

  • Give stored procedure name as GETUMLEREQUIPDETAILS or the exact name, in the structure. It might be case-sensitive.
  • you can set logSQLStatement to true in "advanced mode" section of the communication channel. This will cause the generated SQL statement from XML to show in details page of the audit. You can also use this statement to execute in the actual database.

Hope it helps!

Ambrish