Input Truncated during PLSQL compile [message #8027] |
Tue, 22 July 2003 14:31 |
Alias
Messages: 13 Registered: March 2003
|
Junior Member |
|
|
can someone explain what the following message means:
I am modifying an existing package and don't have a clue as to what this message relates to.
thanks in advance....
SQL> @packcudm
Package created.
Package body created.
Input truncated to 11 characters
No errors.
SQL>
|
|
|
|
Re: Input Truncated during PLSQL compile [message #8030 is a reply to message #8027] |
Tue, 22 July 2003 15:19 |
Art Metzer
Messages: 2480 Registered: December 2002
|
Senior Member |
|
|
Oracle's most cryptic error....it means you have to enter a carriage return after the last line of your package-creation and package-body-creation scripts.
The same error arises if your SQL scripts lack this additional carriage return.
For example, if my file junk.sql is made up of the following three lines:line 1. SELECT dummy
line 2. FROM DUAL
line 3. / then I get:SQL> @junk
Input truncated to 1 characters
D
-
X
SQL> But if to my junk.sql file I add a "return" after the slash, and then resave it:line 1. SELECT dummy
line 2. FROM DUAL
line 3. /
line 4. then I don't get the error when I execute it:Crazy, I know.
Good luck, Alias, if that is indeed your real name.
Art.
|
|
|
Todd & Art [message #8048 is a reply to message #8030] |
Wed, 23 July 2003 06:42 |
Alias
Messages: 13 Registered: March 2003
|
Junior Member |
|
|
thanks guys...
after doing some research myself into the cause..
I went back to the package and did a carriage
return on the last line with text and it solved the
issue.
"Alias".....like a table_name alias...and one of my
favorite TV shows.
|
|
|