Hi everyone, presently I encounter a problem about how to call procedures
through sequoia virtual database
console. Suppose a backend has a procedure in the form 'proc(IN id integer not
null,IN name char(32) not null,
IN score float with null)'. And I tried executing the procedure like this:
{call proc(101,'student',80.0)}
But such statement will raise exceptions from backend database which says
errors like "invalid procedure call
syntax". So I debugged the source code only to find the exceptions occurs from
AbstractLoadBalancer.java, in function
AbstractLoadBalancer::setupCallableStatement(), statement "cs =
c.prepareCall(backend.transformQuery(proc)); ".
If I executed like this:
{call proc(?,?,?)}
The above exception will disappear but no parameters in the procedure was
assigned any value.
So is this a bug in source code ? Or if not, how can I call the procedure
correctly?
Many thanks, expecting your reply!
2009-11-18
wangfugen_000
_______________________________________________
Sequoia mailing list
[email protected]
http://forge.continuent.org/mailman/listinfo/sequoia
