Hi Stephan,
As mentioned privately already, we do not use any of the JDBC APIs for out parameters (CallableStatement). This would have to be added to the SQL processor. However, with Oracle, calling functions and procedures that only take in parameters and function return values will work, assuming you call them by surrounding the function / procedure call with with BEGIN...END.
Let us know how vital enhanced support for stored procedures is for you. Specifically supporting the JDBC CallableStatement is something we may want to add to our list of future improvements.
-Erik
Stephan H. Wissel wrote:
Hi there,
I'm trying to figure out how to use OXF as Front End to our oracle application. So far our test were very promising. However we go stuck on Oracle Stored Procedures. We have some that take parameters and return their values in them. How can I call them from OXF? I only found select and insert/update.
We have a lot of Stored Functions and Stored Procedures.
Help is greatly appreciated.
;-) stw
Stephan H. Wissel
Counsellor for personcentric development
Lotus Notes - Principal CLP & CLI
Mobile: +65 9667 3269
eMail: [EMAIL PROTECTED]
Blog: wissel.net
TAO Consulting PTE LTD
We make IT more useful
10 Anson Road #03-09
Singapore 079903
Fon: +65 7000 TAOTEAM
Fax: +65 6234 3719
Web: www.taoconsulting.com.sg
Web: www.fromDomino.com Training & Coaching l Prototyping & Usability l Solution Architecture l Lotus Domino l IBM WebSphere
SAP on Mobile l Open XML Framework l Primion Time & Access l UMsys Environment IT As for the future, your task is not to foresee it, but to enable it. Antoine de Saint-Exup�ry
------------------------------------------------------------------------
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
