Andrea,
Look at the last line of your procedure. I'll bet you a dozen donuts that
you do not have a carraige return after the last line of typed cdode, and
that the last line of code is 35 chars long.
Simply add a carraige return at the last line.
hope this helps
Tom Mercadante
Oracle Certifi
putting some extra blank line at the very end of the
.sql file will help
Digs
--- Quaglio Andrea <[EMAIL PROTECTED]>
wrote: > I don't know why when I try to load error_p1
> procedure it's printed "Input
> truncated to 35 characters".
>
> SQL> @error_p1
>
> Procedure created.
>
>
Andrea,
Make sure that at the end of your script you don't have additional returns and one
hard return after the last command.
(i.e.
SET OFF
SET OFF
SELECT *
FROM table
/
SET ON
SET ON
<>>>
Hope this helps.
Rick
--
Please see the official ORACLE-
Put a carriage return on you last line of input.
> -Original Message-
> From: Quaglio Andrea [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 24, 2001 10:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Input truncated
>
>
> I don't know why when I try to load error_p1 proced
Hi, Andrea ,
Nothing to worry about. If you want to get rid of this message, remove blank
lines after procedure code.
HTH
Vadim Gorbounov
Brainbench Master Oracle DBA
www.brainbench.com
-Original Message-
Sent: Tuesday, July 24, 2001 10:01 AM
To: Multiple recipients of list ORACLE-L
I d
In your pl/sql script add a carriage return after /
Rick
-Original Message-
Sent: Tuesday, July 24, 2001 10:01 AM
To: Multiple recipients of list ORACLE-L
I don't know why when I try to load error_p1 procedure it's printed "Input
truncated to 35 characters".
SQL> @error_p1
Title: RE: Input truncated
Andrea, put a carriage return after your last slash and this will go away. It's harmless.
Lisa Koivu
Ft. Lauderdale, FL, USA
-Original Message-
From: Quaglio Andrea [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 10:01 AM
To: Mul
Andrea:
Open up your .sql file in notepad or the like and put a carriage
return after the last line so you, in effect, have a final blank
line.
Jon Walthour
>--- Original Message ---
>From: Quaglio Andrea <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date:
Just do a carriage return at the end of the last line. The last line will
be 35 characters long.
Iain
-Original Message-
Sent: 24 July 2001 15:01
To: Multiple recipients of list ORACLE-L
I don't know why when I try to load error_p1 procedure it's printed "Input
truncated to 35 charac
I think it's as simple as no carriage return on the end of the last line
(I'm assuming it's the ';' character).
Cheers
Iain Nicoll
-Original Message-
Sent: 03 May 2001 17:27
To: Multiple recipients of list ORACLE-L
I get the exact same message every time and the procedures always work
You are missing a newline after the / at the end of the procedure.
Pat
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Hildebrand
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Californi
I get the exact same message every time and the procedures always work and there are
no invalid objects in dba_objects. I think you can safely ignore the message. I have
no idea why it comes out, hopefully someone else can spread some light on that.
>>> [EMAIL PROTECTED] 05/03/01 11:56AM >>>
I
Title: RE: Input truncated to 1 characters
Put a carriage return after the / at the end of your file and this will go away.
This is a question on the OCP test, be prepared!
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix
13 matches
Mail list logo