YoForms, YoDeveloper, Yo/SQL demo to go live to partners in August 2013.
more ...

Keep up with our latest news, views and comments on the Snippets page!

people running
"The future of Forms is only just beginning!"

Powered by   in2j

Important: the use of this website is subject to our terms and conditions and privacy policy.



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

Yo/SQL is seamlessly integrated with the other three products comprising the YoServer Suite: YoForms, YoReports and YoDeveloper:


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:

If you would like to participate as a Partner, please contact us now.

PL/SQL background

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.

copyright © 1998-2016 quintessence systems ltd top