DBWS: java.sql.SQLSyntaxErrorException [message #778993] |
Sat, 14 January 2012 10:27 |
Lonneke Dikmans Messages: 2 Registered: January 2012 |
Junior Member |
|
|
Environment:
OEPE 11172 (toplink_11114)
WLS 10.1.3.5
Linux VB
Oracle XE database
HR Schema
I generated a webservice on the procedure ADD_JOB_HISTORY that is part of the hr schema that Oracle delivers with Oracle XE
PROCEDURE add_job_history
( p_emp_id job_history.employee_id%type
, p_start_date job_history.start_date%type
, p_end_date job_history.end_date%type
, p_job_id job_history.job_id%type
, p_department_id job_history.department_id%type
)
IS
BEGIN
INSERT INTO job_history (employee_id, start_date, end_date,
job_id, department_id)
VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;
I generated a webservice with the following builder file:
<?xml version="1.0" encoding="UTF-8"?>
<dbws-builder xmlns:xsd="[link here, not allowed to post : ]">
<properties>
..properties here
</property>
</properties>
<procedure
name="Jobhistory"
catalogPattern="TOPLEVEL"
procedurePattern="ADD_JOB_HISTORY"
isSimpleXMLFormat="true"
/>
</dbws-builder>
When I call this Webservice with SOAP UI
<[not allowed to post header]">
<soapenv:Header/>
<soapenv:Body>
<hrs:Jobhistory>
<hrs:P_EMP_ID>176</hrs:P_EMP_ID>
<hrs:P_START_DATE>2013-02-02</hrs:P_START_DATE>
<hrs:P_END_DATE>2014-02-02</hrs:P_END_DATE>
<hrs:P_JOB_ID>SA_MAN</hrs:P_JOB_ID>
<hrs:P_DEPARTMENT_ID>80</hrs:P_DEPARTMENT_ID>
</hrs:Jobhistory>
</soapenv:Body>
</soapenv:Envelope>
I get the following error:
[EL Warning]: 2012-01-14 11:01:11.478--DatabaseSessionImpl(14802092)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
Error Code: 900
Call: BEGIN ADD_JOB_HISTORY(P_EMP_ID=>?, P_START_DATE=>?, P_END_DATE=>?, P_JOB_ID=>?, P_DEPARTMENT_ID=>?); END;
bind => [176.0, 2013-02-02 00:00:00.0, 2014-02-02 00:00:00.0, SA_MAN, 80.0]
Query: ValueReadQuery(name="Jobhistory" )
However, the row does get added to the database!
Does anybody have any clues?
regards Lonneke
|
|
|
Powered by
FUDForum. Page generated in 0.05365 seconds