Archives of the TeradataForum

Message Posted: Tue, 11 Jun 2002 @ 14:35:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I've written a type 4 JDBC driver for Teradata, and in the JDBC spec, applications call stored procedures by specifying the call statement with the procedure name, and '?' parameter markers for each parameter (in, out, or inout), and which parameters are output parameters. Unfortunately, the JDBC spec doesn't allow for the application to specify the name of any parameters (oddly enough, the application needs to specify the datatype of the out parameters, but cannot specify the name).

So, for the moment, I'm doing the HELP PROCEDURE when the application tries to "prepare" the CALL statement, and re-writing the CALL statement.

This does work, and hides the problem from the application programmer, but the whole point of stored procedures seems to be performance, and this approach isn't very good for performance.

I was just hoping I'd overlooked something, and there was some way to specify an OUT parameter without knowing it's name, so I could get rid of that nasty HELP PROCEDURE call and improve performance.

Charles F McDevitt

www.mcdevitt.san-francisco.ca.us

	<Prev	Next>		<<First	<Prev	Next>	Last>>