The current situation with IN/OUT parameters requires that
considerable juggling is required on the client end to not pass the
OUT parameters in the query. This could be alleviated by adding two
messages for stored procedure calls
1) PrepareCall which sent the types, and direction of the parameters
2) BindCall which sends the binds the parameters to the above
While I have this working with the jdbc driver, the problem I foresee
is that when we do finally implement something like what we have
above. The current driver will be quite difficult to maintain.
Additionally it will be difficult with the current scheme to return
out parameters and a result set.
Is it possible to get this into 8.1, or is this a total non-starter
Dave Cramer
davec@postgresintl.com
www.postgresintl.com
ICQ #14675561
jabber davecramer@jabber.org
ph (519 939 0336 )