|
Description |
this procedure:
create or replace procedure GetCellManagerForJT(aJT llong,aLevel Integer,HowMany integer)
begin
declare CellPtr, aPtr llong;
case
when aLevel = 0 Then
set CellPtr = select objptr_cells from tbl_jobtickets where RecID = aJT;
when aLevel < 0 THEN
set aPtr = select objptr_cells from tbl_jobtickets where RecID = aJT;
set CellPtr = select recid FROM (descendants of aPtr on Level aLevel using cell_has_parent);
when aLevel > 0 THEN
set aPtr = select objptr_cells from tbl_jobtickets where RecID = aJT;
set CellPtr = select recid FROM (ascendants of aPtr on Level aLevel using cell_has_parent);
end case
if CellPtr is null then
raise 50001,'No Cell found on the passed level';
else
if HowMany = 1 then
select RecID from tbl_cellmanagers where objptr_cell = CellPtr limit 1;
else
select RecID from tbl_cellmanagers where objptr_cell = CellPtr;
end if
end if
exception
when others then
raise;
end
Kernel error: 0x71000. line 12:66: expecting UINT, found 'aLevel'
|
Relationships 
Relationships 