Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Examples/DBWS/DBWSComplexArgStoredFunction"
< EclipseLink | Examples | DBWS
Line 11: | Line 11: | ||
The following stored function will be used for this example: <source lang="sql" enclose="div"> | The following stored function will be used for this example: <source lang="sql" enclose="div"> | ||
− | |||
FUNCTION F1(OLDREC IN ARECORD, FOO IN VARCHAR2) RETURN ARECORD IS arec ARECORD; | FUNCTION F1(OLDREC IN ARECORD, FOO IN VARCHAR2) RETURN ARECORD IS arec ARECORD; | ||
BEGIN | BEGIN | ||
Line 21: | Line 20: | ||
</source> | </source> | ||
− | + | Type <code>ARECORD</code> is defined in PL/SQL Package <code>SOMEPACKAGE</code> as follows: <source lang="sql" enclose="div"> | |
− | TYPE TBL1 IS TABLE OF VARCHAR2(111) INDEX BY BINARY_INTEGER; | + | CREATE OR REPLACE PACKAGE SOMEPACKAGE AS |
− | TYPE TBL2 IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; | + | TYPE TBL1 IS TABLE OF VARCHAR2(111) INDEX BY BINARY_INTEGER; |
− | TYPE ARECORD IS RECORD ( | + | TYPE TBL2 IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; |
− | + | TYPE ARECORD IS RECORD ( | |
− | + | T1 TBL1, | |
− | + | T2 TBL2, | |
− | ); | + | T3 BOOLEAN |
+ | ); | ||
+ | FUNCTION F1(OLDREC IN ARECORD, FOO IN VARCHAR2) RETURN ARECORD; | ||
+ | END SOMEPACKAGE; | ||
</source> | </source> | ||
Revision as of 11:18, 10 June 2011
EclipseLink DBWS Service based on Stored Function with complex PL/SQL arguments
The use-case for this example is the creation of a Web service that exposes a simple Stored Function containing complex PL/SQL arguments.
The following stored function will be used for this example:FUNCTION F1(OLDREC IN ARECORD, FOO IN VARCHAR2) RETURN ARECORD IS arec ARECORD;
BEGIN
arec.T1 := OLDREC.T1;
arec.T2 := OLDREC.T2;
arec.T3 := OLDREC.T3;
RETURN arec;
END F1;
BEGIN
arec.T1 := OLDREC.T1;
arec.T2 := OLDREC.T2;
arec.T3 := OLDREC.T3;
RETURN arec;
END F1;
ARECORD
is defined in PL/SQL Package SOMEPACKAGE
as follows: CREATE OR REPLACE PACKAGE SOMEPACKAGE AS
TYPE TBL1 IS TABLE OF VARCHAR2(111) INDEX BY BINARY_INTEGER;
TYPE TBL2 IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
TYPE ARECORD IS RECORD (
T1 TBL1,
T2 TBL2,
T3 BOOLEAN
);
FUNCTION F1(OLDREC IN ARECORD, FOO IN VARCHAR2) RETURN ARECORD;
END SOMEPACKAGE;
TYPE TBL1 IS TABLE OF VARCHAR2(111) INDEX BY BINARY_INTEGER;
TYPE TBL2 IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
TYPE ARECORD IS RECORD (
T1 TBL1,
T2 TBL2,
T3 BOOLEAN
);
FUNCTION F1(OLDREC IN ARECORD, FOO IN VARCHAR2) RETURN ARECORD;
END SOMEPACKAGE;
<?xml version="1.0" encoding="UTF-8"?>
<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<properties>
<property name="projectName">testPLSQLFunction</property>
... database properties
</properties>
<plsql-procedure
name="plsqlfunction"
catalogPattern="SOMEPACKAGE"
procedurePattern="F1%"
returnType="SOMEPACKAGE_ARECORD"
/>
</dbws-builder>
<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<properties>
<property name="projectName">testPLSQLFunction</property>
... database properties
</properties>
<plsql-procedure
name="plsqlfunction"
catalogPattern="SOMEPACKAGE"
procedurePattern="F1%"
returnType="SOMEPACKAGE_ARECORD"
/>
</dbws-builder>
prompt > dbwsbuilder.cmd -builderFile dbws-builder.xml -stageDir output_directory -packageAs wls testPLSQLFunction.war
where
- dbws-builder.xml is the DBWS builder XML file above
- output_directory is the output directory for the generated files
- -packageAs specifies the platform on which the web service will be deployed