DECLARE
err_txt VARCHAR2(80) := Error_Text;
al_id Alert;
al_button Number;
BEGIN
select 'There is '|| to_Char(count(*)) || 'records'
into err_txt
from your_table;
al_id := Find_Alert('ALT_WARNING');
Set_Alert_Property(al_id, alert_message_text, err_txt );
al_button := Show_Alert( al_id );
END;
KRM wrote in message <81egc1$487$1_at_nnrp1.deja.com>...
>Hello.
>
>I would like to display an alert to the user. I know how to create
>alerts and display them. However, I am unsure if the message text can
>be dynamic or not. I want to display a message telling the user how
>many records have been selected. I have this number in a global
>variable. Is there any way to put this into the alert so that the
>message that appears might be something like:
>
>You have selected X records.
>
>Where X is the global variable? The only thing I seem to be able to
>find about messages is that they have to be characters. It seems that
>I cannot display a message that would give the number of records. I
>know I can use the message procedure to display a message, but I want
>to use an alert button so I can have both an OK and a Cancel button.
>Is there a way to do this?
>
>Thanks!
>Kristen
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 23 1999 - 12:40:59 CST
