Alaska Software Inc. - ADS procedure parameters
Username: Password:
AuthorTopic: ADS procedure parameters
Konstantin LebedevADS procedure parameters
on Tue, 09 Aug 2022 10:34:04 +0200
Hello, friends!

This is the sample of stored procedure (in ADS 11)

CREATE PROCEDURE AddRecordToData2
   ( 
      nom_n Integer,
      nCount Numeric ( 12,0 ) OUTPUT
   ) 
BEGIN 

insert into __output (nCount) 
select count(*) nCount
from cart c
where c.nom_n=_nom_n; 

BUT (!) this example doesn't work:

select 
n.nom_n,
(select tv.nCount from (execute procedure AddRecordToData2(n.nom_n)) tv ) nCount
from nsklad n
where
cod=200139

Error: NativeError = 2121;  [iAnywhere Solutions][Advantage SQL Engine]Column not found: nom_n

What's wrong?
PS With ADS Function() it works OK.