Comment on page
MSCEWI1043
Translation for expression not supported.
Medium
This error is used when a specific expression from the source code is not being converted yet but is planned to be delivered in the future.
A null value is inserted to take the expression's place.
CREATE OR REPLACE PROCEDURE EXAMPLE()
IS
CURSOR C1 IS SELECT * FROM TABLE_DATE;
VAR1 INTEGER;
BEGIN
FOR REC1 IN C1 LOOP
IF (REC1.COL1 = VAR1) THEN
VAR1 := 123;
END IF;
VAR1 := REC1.COL1;
END LOOP;
end;
CREATE OR REPLACE PROCEDURE EXAMPLE ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
// Helpers and additional code...
let C1 = new CURSOR(`SELECT * FROM
TABLE_DATE`,() => []);
let VAR1;
C1.OPEN();
while ( C1.NEXT() ) {
let REC1 = C1.CURRENT;
if (REC1.COL1 == VAR1) {
VAR1 = 123;
}
VAR1 = REC1.COL1;
}
C1.CLOSE();
$$;
Last modified 1mo ago