0004693: Kernel error: 0x71000. line 12:66: expecting UINT, found 'aLevel'; request instead of fixed value an expression or variable

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

[VSERVER] 0004693

SQL

feature

always

2010-01-14 16:51

Reporter

Bart Pietercil

View Status

public

Assigned To

Priority

normal

Resolution

open

Platform

Status

new

Projection

none

OS Version

ETA

none

Fixed in Version

Product Version

4.3.1

Target Version

Product Build

Summary

0004693: Kernel error: 0x71000. line 12:66: expecting UINT, found 'aLevel'; request instead of fixed value an expression or variable

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'

Steps To Reproduce

Additional Information

Issue History
Date Modified	Username	Field	Change
2010-01-14 16:51	Bart Pietercil	New Issue

Relationships

Notes
There are no notes attached to this issue.