python error PLS-00306: wrong number or types of arguments in

[Adeoluwa Odein]

Thanks, your assistance will be greatly appreciated on the right way
forward.  See the Stored Procedure Below -very simple:



create or replace package c2_pkg
as
procedure openc;
procedure closec;
procedure RS22(v out varchar);
end;
/

create or replace package body c2_pkg
as
        v_first_time boolean := TRUE;
        v_cursor number;
        cursor srvr_cur
         is
select distinct b.mid from SVR a,VAR b where a.mid = b.mid;

procedure openc
as
begin
        if not srvr_cur%ISOPEN
        then
                open srvr_cur;
        end if;

end openc;

procedure closec
as
begin
                close srvr_cur;
end closec;


procedure RS22(v out varchar2)
as
-- Server varchar2(64);

begin
      Server := NULL;
         fetch srvr_cur into Server;
        v := Server;

end RS22;

end;
/




















On Jul 13, 1:40 pm, John Gordon <gor... at panix.com> wrote:
> In <01efb6ac-deaa-4bdb-8b2d-b603bddde... at n5g2000yqh.googlegroups.com> Adeoluwa Odein <stratfordtena... at gmail.com> 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"
> > error when using the "callproc()" method to execute a stored
> > procedure.



> > The Oracle stored procedure takes a single OUT varchar2 parameter.  My
> > code is as follows:
> > p = [None]
> > c.callproc('pkg1_returns', p);
>
> If the procedure takes a varchar2 parameter, why are you passing [None]?
>
> It might help if you posted the method signature of the Oracle stored
> procedure you're trying to call.
>
> --
> John Gordon                   A is for Amy, who fell down the stairs
> gor... at panix.com              B is for Basil, assaulted by bears
>                                 -- Edward Gorey, "The Gashlycrumb Tinies"