Certified Professional
-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
Procedure created.
Input
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
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.
Input truncated to 35 characters
No errors.
Can anybody help me ?
Thanks,
Andrea
--
Please see the official ORACLE-L FAQ
/01 10:00:47 AM
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.
Input truncated to 35 characters
No errors.
Can anybody help me ?
Thanks,
Andrea
--
Please see the official ORACLE
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: Multiple recipients
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
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.
Input truncated to 35 characters
No errors.
Can anybody help me ?
Thanks,
Andrea
--
Please see the official ORACLE-L FAQ: http
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
one return here and no other lines
after
Hope
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.
Input
noticed when I install procedures, i get this message:
Input truncated to 1 characters
can someone help explain this to me?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
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,
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 noticed when I install procedures, i get this message:
Input truncated to 1
12 matches
Mail list logo