Sql Statement Action: "Bind Variable xxx Not Declared" Error. (Doc ID 431122.1)

Last updated on APRIL 13, 2024

Applies to:

Goal

How can you create an Alert passing a Date parameter to call a procedure?

SELECT :date_last_checked
INTO &pass_var1
FROM dual;

Action--
execute call_by_alert(&pass_var1)

PROCEDURE CALL_BY_ALERT(p_date IN VARCHAR2);

Receive error:
Bind variable "15" not declared (actual number can vary)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.