Keep up with our latest news, views and comments on the Snippets page!
"The future of Forms is only just beginning!"
The high-performance runtime / compiler for Oracle® PL/SQL® code
Completed in October 2012, Yo/SQL is a new Enterprise Java runtime / compiler for Oracle PL/SQL code. Yo/SQL runs on any Java application server (we used Apache Tomcat for development), and supports all the PL/SQL utilised by Forms, including Forms-specific PL/SQL extensions.
Note that a small number of PL/SQL functions are not handled by Yo/SQL but passed to the Oracle database for execution. This is mainly to ensure strict compatibility in, for example, complex date/time handling functions. However we will be prepared to extend Yo/SQL to execute these independent of Oracle database if the demand is there from our users.
YoForms / YoReports / YoDeveloper integration
- YoForms and YoReports call up the Yo/SQL module as needed to execute PL/SQL code, fast and efficiently.
- YoDeveloper contains powerful features to support the development and debugging of PL/SQL code.
- October 2012 - Yo/SQL completed!
- June 2012 - Started to build Yo/SQL based on our existing in2j software.
Become our Partner!
We are looking for Partners with Forms / Reports / PL/SQL applications who are willing to participate in our beta testing and development program. Partners will:
- guide us as to the most important features to implement in Release 1.0 of the product;
- receive free / discounted licenses to run our YoServer products (depending on the depth of involvement in the program).
Originally developed in the early 1980s, PL/SQL is a powerful procedural language (that's where the "PL" comes from) that extends the capabilities of pure SQL in interacting with the database. Its syntax is based on that of Ada and Pascal. Since Oracle database 7 PL/SQL has been included on the database itself. There now exist hundreds of millions of lines of PL/SQL code that provide the essential 'business logic' for countless mission-critical database-focused applications worldwide.
As well as the 'server-side' PL/SQL a second version of the language was developed as part of Oracle Forms, containing functions that allow the programmatic manipulation of the display and execution of Forms applications.
Despite past moves by Oracle to deprecate PL/SQL in favour of more modern languages (Java in particular), developers have stuck firmly with PL/SQL both because of the huge volume of existing PL/SQL code, and because the language permits the rapid, intuitive and highly efficient development of database-focused applications. For these reasons PL/SQL is a major feature of the Oracle computing landscape, and will remain so for many decades to come.