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
[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 >> >________________________________________________________________________ >TO UNSUBSCRIBE: Go to 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: [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
