on 07-18-2013 12:45 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
check with DBA and specify the exact SP name. See any schema you need to reference the SP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
Few suggestions:
Hope it helps!
Ambrish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.