Archives of the TeradataForum
Message Posted: Wed, 20 Feb 2002 @ 13:40:41 GMT
Subj: | | Re: Out Parameter |
|
From: | | Geoffrey Rommel |
| How to access values in out/inout parameter in a call to SP? | |
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 (??).
--wgr
|