My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Alert - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

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