Hello
I am using the zxJDBC package with jython (similar to python), and I
am having "python error PLS-00306: wrong number or types of arguments"
error when using the "callproc()" method to execute a stored
procedure.
The Oracle stored procedure takes a single OUT varchar2 parameter. My
code is a
c-deaa-4bdb-8b2d-b603bddde...@n5g2000yqh.googlegroups.com>
> Adeoluwa Odein writes:
>
> > Hello
> > I am using the zxJDBC package with jython (similar to python), and I
> > am having "python error PLS-00306: wrong number or types of arguments"
> > erro
a
cursor fetch; even a minor text assignment.
On Jul 13, 2:10 pm, John Gordon wrote:
> In <9e937261-d05d-477a-90d2-a690e85e1...@h17g2000yqn.googlegroups.com>
> Adeoluwa Odein writes:
>
> > Thanks, your assistance will be greatly appreciated on the right way
> > forw
On Jul 13, 2:26 pm, John Gordon wrote:
> In
> Adeoluwa Odein writes:
>
> > The actual jython/python call is:
It's taking an OUT parameter.. I'm just following the examples as
documented by zxJDBC. How can I fix it?
> > p =3D [None]
> > c.cal
On Jul 13, 2:26 pm, John Gordon wrote:
> In
> Adeoluwa Odein writes:
>
> > The actual jython/python call is:
> > p =3D [None]
> > c.callproc('c2_pkg.RS22', p);
> > I used a placeholder initially; now that you have the SQL code, there
> > it is.
On Jul 13, 4:09 pm, John Gordon wrote:
> > It's taking an OUT parameter.. I'm just following the examples as
> > documented by zxJDBC. How can I fix it?
>
> I suspect the example you're looking at was for a procedure which has no
> arguments, so in that case it would make sense to pass an empty p
On Jul 13, 5:02 pm, John Gordon wrote:
> In <86b9e6f2-e18e-41b9-92a2-86ea8d7b4...@f35g2000vbr.googlegroups.com>
> Adeoluwa Odein writes:
>
> > The same error. The sample were found on the following site --I copied
> > exactly what is written there:
> > 1.http
On Jul 13, 5:19 pm, John Gordon wrote:
> In <0730c5fb-3b65-45ce-9cc5-69d639f48...@g2g2000vbl.googlegroups.com>
> Adeoluwa Odein writes:
>
> > if you define the function in the execute() method, it works (as seen
> > on the page). But this is a stored procedure alr
On Jul 13, 5:19 pm, John Gordon wrote:
> In <0730c5fb-3b65-45ce-9cc5-69d639f48...@g2g2000vbl.googlegroups.com>
> Adeoluwa Odein writes:
>
> > if you define the function in the execute() method, it works (as seen
> > on the page). But this is a stored procedure alr
