getting error [5531: HY000] with a simple store proc

Database

getting error [5531: HY000] with a simple store proc

Hi, I have a simple store procedure created. but when i try to run it. Its throwing an error:

Failed [5531 : HY000] Named-list is not supported for arguments of a procedure

Satetment 1: Unknown failed.

Here is the store procedure:

create procedure "retail".testCount(out cnt integer)

begin

select 10 into cnt;

end;

The procedure is being created, but not run correctly. Any help really appreciated!

2 REPLIES
Teradata Employee

Re: getting error [5531: HY000] with a simple store proc

So what does the CALL statement look like?

Re: getting error [5531: HY000] with a simple store proc

call procedure "retails".testCount();

But then after some reseach I read that we need to pass a dummy variable, so I changed to

call procedure "retails".testCount(dumm); -> this worked! Thanks Fred!