Hi Erik,
thx for the detailed reply. We test the BEGIN END approach now and see how it goes. The support for functions/stored procedures is VERY vital for us. I would suggest you put that in the list of enhancements to do, but without a priority. Once my client has decided to standardize on OXF and placed the first orders with you, you add a priority.
;-) stw
[EMAIL PROTECTED] wrote on 02/06/2004 04:43:29:
> 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
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
