User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle Business Logic to HiRDB
Procedures
SQL%NOTFOUND
CURSOR_NAME%NOTFOUND
SQL%FOUND
CURSOR_NAME%FOUND
SQL%ROWCOUNT
CURSOR_NAME%ROWCOUNT
Variable Declaration
CONSTANT declaration
Comment
CURSOR
%TYPE in Create Table DDL
%TYPE not in Create Table DDL
%ROWTYPE in Create Table DDL
%ROWTYPE not in Create Table DDL
%ROWTYPE for cursor declaration
Boolean
CLOSE cursor
EXECUTE IMMEDIATE
FETCH
OPEN cursor with parameters
OPEN cursor without parameters
Assignment Operator :=
IF
EXIT
EXIT … WHEN
WHILE LOOP
LOOP
FOR LOOP
FOR LOOP … IN REVERSE
FOR LOOP cursor (cursorname is omitted)
FOR LOOP cursor (cursorname is specified)
RETURN (in function)
RETURN（in procedure）
DBMS_OUTPUT.PUT_LINE
RAISE
RAISE exception_name
SQLCODE (in exception handler)
SQLCODE
SQLERRM (in exception handler)
DECLARE EXCEPTION
Exception Handler
EXCEPTION_INIT
SQL%NOTFOUND = TRUE
SQL%FOUND = TRUE