Re: sqlplus message

"Denny Dutcavich" <dut_at_mindspring.com> wrote in message news:9hqmrm$hdi$1_at_nntp9.atl.mindspring.net...
> I get the following message when I logon using my login profle. I get the
> message every time but don't know why
>
> SQL> _at_login
> You are logged into database PROD1.
> You are logged in as user DUTCH.
> Today is the 02ND of Jul, 2001 and the time is 16:28.
> Input truncated to 14 characters *** Why di I get this message????***
>
>
> the script
> SET HEADING OFF
>
> SET LINESIZE 132
>
> SET PAGESIZE 66
>
> SELECT 'You are logged into database '|| name ||'.'
>
> FROM v$database;
>
> SELECT 'You are logged in as user '|| user ||'.'
>
> FROM DUAL;
>
> SELECT 'Today is the '|| to_char(SYSDATE, 'DDth "of" Mon"," yyyy') ||
>
> ' and the time is ' || to_char(SYSDATE, 'hh24":"mi') || '.'
>
> FROM DUAL;
>
> SET HEADING ON
>
> Thanks for any help...
>
>
>

Because there's no newline after the last command in your file.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Jul 22 2001 - 08:55:31 CEST