Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Stored procedure calls with OUT paramters, how?
From:   Charles McDevitt

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


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020