<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="PO_REQUEST">
<xs:complexType>
<xs:sequence>
<xs:element name="StatementName" maxOccurs="unbounded" minOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="storedProcedureName">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="table"/>
<xs:element name="ORDERNO" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute type="xs:string" name="type"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="ORDERDATE" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute type="xs:string" name="type"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="MATERIAL" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute type="xs:string" name="type"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="QUANTITY" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute type="xs:string" name="type"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:string" name="action"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
<StatementName>
<storedProcedureName action=" EXECUTE">
<table>realStoredProcedureeName</table>
<param1 [isInput="true"] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName>
The following SQL data types are supported:
INTEGER, BIT, TINYINT, SMALLINT, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL, CHAR, VARCHAR, STRING, LONGVARCHAR, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, BLOB (input and output), CLOB (input and output), CURSOR (output; only in connection with the Oracle JDBC driver)
<?xml version="1.0" encoding="UTF-8"?>
<Root>
<record>
<ORDERNO>125</ORDERNO>
<ORDERDATE>2020-12-01</ORDERDATE>
<MATERIAL>MPAM731980</MATERIAL>
<QUANTITY>421633</QUANTITY>
</record>
<record>
<ORDERNO>126</ORDERNO>
<ORDERDATE>2020-12-01</ORDERDATE>
<MATERIAL>MPAM731980</MATERIAL>
<QUANTITY>421633</QUANTITY>
</record>
<record>
<ORDERNO>127</ORDERNO>
<ORDERDATE>2020-12-01</ORDERDATE>
<MATERIAL>MPAM731980</MATERIAL>
<QUANTITY>421633</QUANTITY>
<record>
<ORDERNO>132</ORDERNO>
<ORDERDATE>2020-12-01</ORDERDATE>
<MATERIAL>MPAM731980</MATERIAL>
<QUANTITY>421633</QUANTITY>
</record>
</Root>
CREATE PROCEDURE UPSERT_ORDERDETAIL_DEMO(
IN "ORDERNO" varchar(100),
IN "ORDERDATE" varchar(50),
IN "MATERIAL" VARCHAR(150),
IN "QUANTITY" DOUBLE
)
LANGUAGE SQLSCRIPT AS
BEGIN
DECLARE MYCOND CONDITION FOR SQL_ERROR_CODE 301;
DECLARE EXIT HANDLER FOR MYCOND
BEGIN
update "PACCAR_DB"."ORDERDETAIL_DEMO" set QUANTITY = QUANTITY+:QUANTITY where
ORDERNO = :ORDERNO;
end;
INSERT INTO "PACCAR_DB"."ORDERDETAIL_DEMO"
VALUES (
:ORDERNO,
:ORDERDATE,
:MATERIAL,
:QUANTITY);
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
4 |