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.