Archives of the TeradataForum
Message Posted: Wed, 20 Feb 2002 @ 13:40:41 GMT
If your procedure is defined thus:
create procedure proc001 (in invar01 integer, out outvar02 integer ) begin set outvar02 = invar01 + 5; end;
then call it thus:
call proc001(24, outvar02);
Note that you must give the actual variable name of the output variable. In the example above, you must use "outvar02" -- no other name will work.
The above will work from BTEQ or Queryman. I don't know about INOUT variables; those may work only from embedded SQL (??).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|