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