Ben, Unfortunately, the @BIND function did not stop the procedure from crashing the server as a JDBC data source. (I was already using @BIND with the OUT parameters, just not with the IN parameters.) I would welcome hearing any other suggestions the group might have to offer.
~ Pam You will need to use the <@BIND> function inside the direct dbms check out page 119 in 5.5 programmers guide Ben On Mar 14, 2008, at 1:07 PM, Pamela Hubley wrote: Ben, I should have stated in my post that the procedure returns three (3) out parameters, so a select statement will not work. In order to use one procedure for both WiTango and in another non-web development environment, the procedure has to produce three out parameters to be in synch with existing applications. Any other suggestions? Pam [ mailto:[email protected] [EMAIL PROTECTED] writes: have you tried select procedure(param1,param2) Ben On Mar 14, 2008, at 8:17 AM, Pamela Hubley wrote: Greetings ~ How do you call a PL/SQL procedure in a Direct DBMS using a JDBC data source? When we did this using WiTango version 5.5, it crashed the development server. The call was structured as follows: procedure_name(parameter1, parameter2) We did not use "begin" or "end" or semi-colons in the call to the procedure. Thanks in advance for any and all suggestions. Pam Hubley Harvard University - DCE ________________________________________________________________________ TO UNSUBSCRIBE: Go to [ http://www.witango.com/developer/maillist.taf ]http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to [ http://www.witango.com/developer/maillist.taf ]http://www.witango.com/developer/maillist.taf Thanks! Pam Hubley Senior Programmer Programming Manager Harvard University - DCE Phone : 617.998.8519 FAX : 617.495.9176 e-mail: [ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to [ http://www.witango.com/developer/maillist.taf ]http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
| You will need to use the <@BIND> function inside the direct dbms check out page 119 in 5.5 programmers guide Ben On Mar 14, 2008, at 1:07 PM, Pamela Hubley wrote: Ben, ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf |
