RE: [Info-ingres] can stored procs be called without naming the parameters ?
- From: "Croker, Grant" <Grant.Croker@xxxxxx>
- Date: Wed, 24 Aug 2005 11:14:36 +0100
> Just a quickie -
>
> Anyone know if there's a syntax for calling a stored proc without
having
> to name the individual parameters ?
>
> i.e. exeStr = "execute procedure
someUserCreatedMethod(4,'frog',23,234)"
>
> I won't know at design time what the names of each parameter will be,
> but I will be gauranteed that the param values I use to call it will
be
> typed correctly
I have a newer version of the python interface for Ingres that is closer
to Python's DBI 2.0. It supports cursor.callproc and should, in theory
do what you are looking for. Let me know if you are interested in trying
it out. Python 2.4 is needed for timestamp support.
grant (code pimp)
.
- Prev by Date: [Info-ingres] Database security - best practices
- Next by Date: Re: [Info-ingres] Re: Checkpoint Fail: tar: The file aaajpnid.t00 is to large
- Previous by thread: [Info-ingres] Database security - best practices
- Next by thread: RE: [Info-ingres] can stored procs be called without naming the parameters ?
- Index(es):