Select parameter output

[Robert Ouzen]

Hi to all

Somebody know how to create a parameter output for further use in a select
command.
Here my example to get a number request for a reply command:

    select substr(message,10,3) as "Request ID" from actlog where msgno=8373
and current_timestamp-date_time<'0 00:01:00.000000'

>From this select I got the request number to apply for the reply command how
can I supply this output directly to my command reply ??????

T.I.A Regards

Ouzen Robert
E-mail:[EMAIL PROTECTED]