Archives of the TeradataForum
Message Posted: Mon, 10 Jun 2002 @ 21:15:58 GMT
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?
Charles F McDevitt
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|