Hello,
PL/SQL in Oracle EXDI does not differe from plain SQL that much.
This example shows how to use PL/SQL. Basically you have to:
1) parse the statement
2) bind the input parameter
3) create the buffer for the output parameters
4) bind the output parameters
5) execute the statement
6) read the output parameters.
The PLSQL package sinply count the size of the array passed as parameter
CREATE OR REPLACE PACKAGE PACK_SIZE
-- -------------------------------------------------------------------------
---
-- Exampe package for showing OracleEXDI Bug in handling Arrays when
-- caching the session cursors
--
-- -------------------------------------------------------------------------
---
AS
TYPE NUM_T_type IS TABLE OF NUMBER index by pls_integer;
PROCEDURE GET_SIZE (p_NumTab IN NUM_T_type, p_Size out NUMBER);
END PACK_SIZE;
/
CREATE OR REPLACE PACKAGE BODY PACK_SIZE
AS
PROCEDURE GET_SIZE (p_NumTab IN NUM_T_type, p_Size out NUMBER)
IS
BEGIN
p_Size := p_NumTab.COUNT;
END GET_SIZE;
END PACK_SIZE;
/
The following workspace executes the procedure in the package
| connection session data count |
(connection := OracleConnection new)
environment: <the database>;
username: <the user>;
password: <the users password>;
connect.
session := connection getSession.
[session preparePLSQL: 'begin PACK_SIZE.GET_SIZE(:data, :size); end;'.
data := OrderedCollection new: 10.
1 to: 10 do: [:index | data add: index].
session bindVariable: #size value: 0.
session bindVariable: #data value: data type: Integer size: nil.
session execute.
session answer.
count := (session bindVariable: #size)] ensure: [session disconnect].
Hope this helps
Clemens Hoffmann
Original Message:
-----------------
From: Steve Aldred
[hidden email]
Date: Tue, 05 Aug 2008 12:21:40 +1000
To:
[hidden email]
Subject: [vwnc] Oracle stored procedures Glorp/Exdi vw7.6
Has anybody successfully used VW7.6 to call Oracle stored procedures?
We know Glorp is missing this functionality but we can't see how
OracleEXDI can do it either.
An example would be great.
thanks
Steve
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc--------------------------------------------------------------------
mail2web LIVE Free email based on Microsoft® Exchange technology -
http://link.mail2web.com/LIVE_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Locked
