OrindaBuild 2.0 - A Tool that generates Java to Call Oracle PL/SQL procedures

OrindaBuild 2.0 - A Tool that generates Java to Call Oracle PL/SQL procedures

Post by OrindaSoft » Fri, 10 Oct 2003 00:21:17

What is OrindaBuild?

OrindaBuild?is a utility that automatically writes Java?code to access
stored procedures, packages, functions and sequences in Oracle?
databases. By automating the tedious task of writing access code, it can
dramatically improve productivity. OrindaBuild also helps to reduce the
time taken for Java code to catch up with database design changes.

How does it work?

OrindaBuild has a Swing GUI to choose Oracle database resources like
PL/SQL?procedures. Specify the location for code generation, add your
comments and other configuration information and click Generate. All the
source you need is either created or ships with the product. There is no
mysterious runtime component and your code continues to work when your
license expires.

Key Features:

Intuitive and straightforward -
A Swing GUI lists existing PL/SQL objects and makes creating code trivial.

No mysterious runtime component -
Everything is done with human readable source code.

No Precompilers needed -
No requirement to use SQLJ.

Large object support -
BLOBs, CLOBs and BFILE parameters can be treated as java.io.File.

Cursor Support -
Cursors can't be left open and are retrieved into a standard data structure.

Understands Oracle's privileges -
Can call PL/SQL objects owned by other users or referred to by Synonyms.

Support for BOOLEAN parameters -
Can call PL/SQL procedures with BOOLEAN parameters without having to
create an additional procedure.

Support for records as parameters -
Can call PL/SQL Procedures that have %ROWTYPE, %TYPE, PL/SQL Package
Record and Oracle Object Type Parameters provided they don't have nested

No Schema Changes -
OrindaBuild does not create any additional database objects such as
Procedures or Tables.

Pay-As-You-Go Licensing -
OrindaBuild is available for periods ranging from one month to a year.
When the license expires you can maintain the code by hand. Generated
code does not stop working because your licence has expired.

Standard Windows App -
OrindaBuild comes as a standard Windows installable and can be safely
uninstalled when no longer required.

Command Line Support -
Code can be generated on any platform the supports Sun Java, thus
enabling OrindaBuild to be integrated with tools such as 'make' and 'ant'.

Downloading OrindaBuild

Orinda Software's web site is located at:

A fully functional Version of OrindaBuild can be downloaded from:

About Orinda Software

Orinda Software is a privately held startup located in Dublin, Ireland.

Orinda's mission is to create easily usable products that improve
productivity for people who use Oracle, Java and JDBC.

Orinda Software is a Sun Independent Software Vendor and a Paypal
Verified Merchant.

"OrindaBuild" and "Orinda Software" are trademarks of Orinda Software, Ltd.

Remove FRUITBAT for a valid Email address..

1. OrindaBuild 4.0 - Now provides DAO to run Oracle PL/SQL Procs fromJava...

2. possible to call PL/SQL from Java stored procedure?

is it possible to call a pl/sql stored procedure from a java stored
procedure? (oracle

any direction/experience/war stories on this would be appreciated:

flame prevention:

[_] yes, i am researching this
[_] i have not done java stored procedures, but i am managing a project
where a programmer (that knows java but not pl/sql) wants to integrate some
java code into an existing process
[_] yes, i am willing to read the manual if you provide a reference
[_] no, i'm not selling anything ;-)

;-{ mcs

3. Calling Cursoring Oracle PL from SQL SERVER 2000 PL

4. Problem calling pl/sql procedure from sql query

5. Call pl/sql procedure into a sql query

6. Call PL/SQL Procedure in MS SQL Server

7. Java/J2EE PA(Oracle,SQL,PL/SQL)

8. Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server

9. Calling Oracle Stored Procedure from within SQL Server Stored Procedure

10. Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server

11. OrindaBuild 5.0 Launched - Creates Java to Connect Oracle To Axis

12. OrindaBuild Java service generator for Oracle now available as an Eclipse 3.3 Plugin...

13. How can i catch an exception generated by a PL/SQL stored procedure?

14. Orphan REF cursor returned to VB.NET from Oracle PL/SQL stored procedure?

15. How to pass a boolean parameter to an oracle PL/SQL procedure