Re: SQL*Plus error message ?
Date: 24 Jan 2002 01:01:23 -0800
Message-ID: <a20d28ee.0201240101.2e4ca44e_at_posting.google.com>
av999_at_canada.com (Alex) wrote in message news:<3d155f5d.0201231311.6aba12d3_at_posting.google.com>...
> Hi,
>
> I'm running this login.sql script on Oracle 8.1.5, to set the
> sqlprompt to the name of the instance I connect to:
>
> col my_dbname noprint new_value dbname
> select global_name my_dbname from global_name;
> set sqlprompt '&dbname sql> '
>
>
> And I am getting this error message (or warning):
>
> Input truncated to 29 characters
>
>
> What does it mean ? How do I get rid of it ?
>
> Alex
set sqlprompt '&dbname sql> '<CR/LF'
Always conclude the last command with a <RET> or you will get this *warning* (it is not an *error*, please verify in the manual)
Hth
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jan 24 2002 - 10:01:23 CET