Variables in BTITLE or TTITLE

From: Kurt R. Nowacki <knowacki_at_airadigm.com>
Date: Wed, 21 Apr 1999 09:14:07 -0500
Message-ID: <7fkmkb$12g$1@news.inc.net>

I'm trying to put a person's name into the BTITLE or TTITLE. The full name (two separate words) are sent into the SQL*Plus script as the first variable. When I put them into the TTITLE, it only prints out the first name.

Ex.

SQL*Plus program is called like this:

                program1.sql  'JOHN DOE'

The formatting looks like this:

                BTITLE CENTER '** PLEASE RETURN TO &1 **'

When the report prints out, the bottom title is this:

• PLEASE RETURN TO JOHN **

How can I print out the full name of the person on the bottom title so that it reads:

• PLEASE RETURN TO JOHN DOE **

Please reply to my email as well, as I don't get onto the ng as much as I'd like. Thanks!

Kurt Nowacki
knowacki_at_airadigm.NOSPAM.com
Airadigm Communications Received on Wed Apr 21 1999 - 09:14:07 CDT