#9 TO_CHAR is not a known function

[David Maier]

The transformation result (transformation happens via the Idiom parsers in this case) for procedures may not handle the TO_CHAR function. So there is an execution error during the creation of such procedure. I remember that Ingres 10 should contain such a function for compatibility reasons, but Ingres 9.3.1 (the latest stable GA) does not. So we should replace it by using our common type cast functions.

[David Maier]

CREATE PROCEDURE secure_dml AS BEGIN
IF TO_CHAR(DATE('now' ) , 'HH24:MI' ) NOT BETWEEN '08:00' AND '18:00'
OR TO_CHAR(DATE('now' ) , 'DY' ) IN ('SAT' , 'SUN' )
THEN
;
/* #NOTSUPPORTED# Convert to Ingres.
(ORA_PARAM 'You may only make changes during normal office hours') */
;
END;