Imam sp koja pocinje ovako:
create procedure ConvertToKG
(
"rWEIGHT" numeric(18,2),
" cWUM" VARCHAR(20) CHARACTER SET ISO8859_1
)
returns
( "results" boolean)
as
declare variable um$um_Basic numeric(18,2);
declare variable um$um_Conv_Basic numeric(18,2);
declare variable um$um_Conv_Other numeric(18,2);
declare variable um$basic_Um_Id varchar(3);
declare variable um$other_Um_Id varchar(3);
declare variable um$um_System numeric(1,0);
declare variable rFactBasicW numeric(18,2);
declare variable iSystemW integer;
begin
select UM_BASIC, UM_CONV_BASIC, UM_CONV_OTHER, BASIC_UM_ID, OTHER_UM_ID, UM_SYSTEM
from UM where UM_ID = :cWUM
into :um$um_Basic, :um$um_Conv_Basic, :um$um_Conv_Other, :um$basic_Um_Id, :um$other_Um_Id, :um$um_System ;
if ( (um$um_Basic is null) and (um$um_Conv_Basic is null) and (um$um_Conv_Other is null) and (um$basic_Um_Id is null)
and (um$other_Um_Id is null) and (um$um_System is null) ) then
begin
results = false;
exit;
end;
rFactBasicW = um$um_Conv_Basic;
....itd..
i kada je pokrenem dobijem poruku :"Parsing Error invalid statement on line 0: rFactBasicW = um$um_Conv_Basic; "
U cemu je greska?