Archives of the TeradataForum

Message Posted: Mon, 10 Jun 2002 @ 21:15:58 GMT

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

I have a situation where I want to call a stored procedure. This stored procedure is known to have three out parameters, But the application doesn't know the name of these parameters.

In other database systems, using normal dynamic SQL, I would call The procedure with SQL like "call myproc(?,?,?);".

But apparently Teradata doesn't like this. If I knew the name of the parameters, I could call it like "call myproc(paramx,paramy,paramz);", and that would work.

But is there any way to call a stored procedure that has OUT parameters without knowing the OUT parameter names?

Thanks!

Charles F McDevitt

www.mcdevitt.san-francisco.ca.us

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