Is it possible to run a PL/SQL statement in an Oracle Alert action?
Hello
did anyone know is it possible to run a PL/SQL statement in an Oracle Alert action?
I can run an SQL like “UPDATE Table SET alert_run = 'ok' where id = 10;” but if I run instead of this the following
“Select XXKN_TEST.UPDATE_XXX_TEST('&USER_NAME') From dual;”
I get the following error log:
-------------------------------------------------------------------------
Alert: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ALECDC module: Check Periodic Alert
-------------------------------------------------------------------------
PL/SQL procedure successfully completed.
XXKN_TEST.UPDATE_XXX_TEST('GROSS2')
*
ERROR at line 2:
ORA-00904: "XXKN_TEST"."UPDATE_XXX_TEST": invalid identifier
APP-ALR-04020: Oracle Alert was unable to execute "&VALUE". Check that this file exists and that its read protection is set correctly.
I can run an SQL like “UPDATE Table SET alert_run = 'ok' where id = 10;” but if I run instead of this the following
“Select XXKN_TEST.UPDATE_XXX_TEST('&USER_NAME') From dual;”
I get the following error log:
-------------------------------------------------------------------------
Alert: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ALECDC module: Check Periodic Alert
-------------------------------------------------------------------------
PL/SQL procedure successfully completed.
XXKN_TEST.UPDATE_XXX_TEST('GROSS2')
*
ERROR at line 2:
ORA-00904: "XXKN_TEST"."UPDATE_XXX_TEST": invalid identifier
APP-ALR-04020: Oracle Alert was unable to execute "&VALUE". Check that this file exists and that its read protection is set correctly.
0