on 05-31-2013 8:26 AM
I have these SP:
procedure ws004_facturacion(
p_tipo_id in tp24_ventas.cp24_tipo_id_contacto%type, --varchar2
p_numero_id in tp24_ventas.cp24_numero_id_contacto%type, --mumber
p_descripcion in tp24_ventas.cp24_descripcion%type, --varchar2
p_cod_puesto in varchar2,
p_usuario in tp24_ventas.cp24_usuario_creacion%type, --varchar2
p_jorcaj in tp24_ventas.cp24_cp08_jorcaj_codigo%type, --number
p_preliquidacion in clob,
p_medios_pago in clob,
p_fact out clob)
p_preliquidacion
<pretarif>
<pretarif_r>
< tipo_producto>B</tipo_producto>
< codigo>10</codigo>
< valor>25500</valor>
< porcentaje_iva>0</porcentaje_iva>
< descripcion>PARTICULAR</descripcion>
< cat_codigo>D</cat_codigo>
< tipo_edad>N</tipo_edad>
< seguro>0</seguro>
< sub_total>25500</sub_total>
</pretarif_r>
<pretarif_r>
<tipo_producto>B</tipo_producto>
<codigo>10</codigo>
<valor>25500</valor>
<porcentaje_iva>0</porcentaje_iva>
<descripcion>PARTICULAR</descripcion>
<cat_codigo>D</cat_codigo>
<tipo_edad>N</tipo_edad>
<seguro>0</seguro>
<sub_total>25500</sub_total>
</pretarif_r>
</pretarif>
p_medios_pago
<ROWSET>
<ROW>
< valor>10500</valor>
< id_mpago>1</id_mpago>
< id_banco></id_banco>
< nro_doc></nro_doc>
<nro_autoriz></nro_autoriz>
< nro_cta_cheque></nro_cta_cheque>
</ROW>
<ROW>
< valor>14500</valor>
< id_mpago>2</id_mpago>
< id_banco>123</id_banco>
< nro_doc>4567890</nro_doc>
< nro_autoriz>12345</nro_autoriz>
< nro_cta_cheque>67890</nro_cta_cheque>
</ROW>
</ROWSET>
I created the Interface in SAP PI as:
<yq1:SoapFacturacionReq_mt xmlns:yq1="http://Colsubsidio_Factura_WS004.com/soap2jdbc/sync" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
It is type mismatch, take payload from moni and share with DB guys to debug, it look problem with test data,if possible test with real data and see results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please refer this link
http://nimishgarg.blogspot.com/2012/08/ora-06512-at-line-num.html
"The ORA-06512 error itself does not indicate the actual error. It normally indicates the line number at which the oracle PL/SQL code has caused an error. There will be another main error occurred in your process and that error happened in the line number as mentioned in ORA-06512 message description."
The above error is not due to structure mismatch or problem in PI side. The error occurs at db level. Also check what outgoing data from PI causes in oracle side. Take help from DBA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Leonardo,
Go through the below links and make sure that, you have followed all the steps
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Also Try this
http://www.flickr.com/photo_zoom.gne?id=1449322648&size=o
Regards
Bhargava krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.