Oracle Virtualization and Cloud Consulting
view counter

App Development Feed

Oracle application development and Oracle database application development resources, news, and support articles.

Created the first version of the JavaFX Browser inside Oracle Forms

I created the first version of the JavaFX browser inside Oracle Forms.

It still needs some adjustments, but the first version can be found at

Connections Types in SQLcl

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same way using SQLcl as with SQL*Plus.

Code Insight on SQLcl

Here's a little preview of the code insight we have in SQLcl.  These changes are part of EA2 which are coming out very soon.  This also shows the buffer and cursor management which was introduced in SQLcl

Playing around with JavaFx inside Oracle Forms

Sometime ago someone asked me some questions about the Enhanced java bean. That java bean was based on the JDIC (java desktop integration component) of sun. The project of  jdic hasn't been updated for quite some time. So the java bean is getting harder to use.

So I was searching for a different solution, when I stumbled on JavaFX. I now have the following results:

APEX EA3 released

The third and final early access release of Oracle Application Express (APEX) 5.0 is now released on  Our packaged applications now install much faster; I was able to install p-track (all 166 pages) in 22 seconds.  Our packaged apps now all use our new "universal theme", which is also available when creating custom apps.  The developer interface has been modernized and streamlined.  APEX 5.0 supports model dialogs, theme-rollable theme styles, a slick new page designer, and improved interactive reports.

3 new things about sdsql

New Name !
The first is a new name this EA it's named sqlcl for sql command line.  However, the binary to start it up is simply sql.  Nothing is easier when you need to run some sql than typing 'sql' and hitting enter.

#./sql klrice/klrice@//localhost/orcl

SQLcl: Release 4.1.0 Beta on Fri Jan 30 12:53:05 2015

Copyright (c) 1982, 2015, Oracle. All rights reserved.

Connected to:

Grails on Openshift

I created a simple Grails application which makes it possible to store client data inside a MySQL database. I created this application since I want to learn more about GORM (Grails Object Relational Mapping).

I already tested the application in the internal server from Grails, but I wanted to deploy it to a remote server. So I created a development account on Openshift and there I created the following server:

SQLCl - LDAP anyone?

since  we released our first preview of SDSQL, we've made  a lot of changes to it and enhanced a lot of things too in there so it would be more useable.  One specific one was the use of LDAP which some customers on SQLDeveloper are using in their organisations as a standard and our first release precluded them from working with this.

Well, to add this, we wanted a way that we could specify the LDAP strings and then use them in a connect statement.  We introduced a command called SET LDAPCON for setting the LDAP connection.  You can set it like this at the SQL> prompt

Oracle 12c Implicit Result Sets in SQL Developer 4.1

Ever want to run a Stored Procedure or a PL/SQL anonymous block and just want to "print out" the results of a query ?  Even as a little bit of debug information?

In Oracle 11g you have to create a SQL*Plus REFCURSOR variable and then bind it within the anonymous block  or  pass it as an argument to a procedure/function. Run the code and then print the refcursor.

This requires a bit of know how in SQL*Plus and how it will work with your PL/SQL block or procedure.

view counter