h3. The OrindaBuild 6.0 SQL Developer Extension has significant new functionality and is now in
Beta.
OrindaBuild is a well known Third Party extension for JDeveloper and SQL Developer that generates Java to run your PL/SQL and SQL.
Earlier versions of OrindaBuild matched the functionality of JPublisher but also suffered from the same limitation - it could only handle array parameters if they were defined as Oracle TYPE objects. Since the majority of pre-existing legacy PL/SQL uses arrays defined inside PL/SQL packages this was a significant drawback, as in practice accessing a complex pre-existing PL/SQL package from Java meant making modifications to the code.
OrindaBuild 6 overcomes this limitation and can write [Java source code|http://www.orindasoft.com/public/Java2HTML/com/orindasoft/demo/generated/plsql/PackageArrayExampleAddBookingsPlsqlArray.java.html] to handle arrays defined inside PL/SQL packages. An example of such a procedure is:
PACKAGE PACKAGE_ARRAY_EXAMPLE AS
--
TYPE FLIGHTS_PLSQL_ARRAY IS TABLE OF FLIGHTS%ROWTYPE;
--
TYPE BOOKINGS_PLSQL_ARRAY IS VARRAY(30) OF BOOKINGS%ROWTYPE;
--
PROCEDURE [GET_PLSQL_ARRAY_OF_FLIGHTS|http://www.orindasoft.com/public/Java2HTML/com/orindasoft/demo/generated/plsql/PackageArrayExampleGetPlsqlArrayOfFlights.java.html]
(P_CITY IN FLIGHTS.DEPARTURE_CITY%TYPE
,P_FLIGHTS_FROM OUT NOCOPY FLIGHTS_PLSQL_ARRAY);
--
PROCEDURE [ADD_BOOKINGS_PLSQL_ARRAY|http://www.orindasoft.com/public/Java2HTML/com/orindasoft/demo/generated/plsql/PackageArrayExampleAddBookingsPlsqlArray.java.html]
(P_CUSTOMER IN CUSTOMERS%ROWTYPE
,P_BOOKING_TABLE IN BOOKINGS_PLSQL_ARRAY
,P_STATUS_MESSAGE OUT NOCOPY VARCHAR2);
--
END PACKAGE_ARRAY_EXAMPLE;
h3. Using OrindaBuild with JDeveloper 11G
OrindaBuild is available as a Third Party extension. Select "Help", "Check for Updates" and then "Open Source and Partners Extensions" to access the demo version. The demo expires after 30 days but you can re-install as many times as you want. For more information see
here.
h3. Known OrindaBuild 6 Beta Issues:
At this time we are aware of a
bug that appears to be associated with creating connections to non-Oracle databases. We would therefore not recommend that you download the beta if you are doing this. We welcome OrindaBuild 6 bug reports at jdev11_2614_support at orindasoft.com.