bug while editing package

[phko]

Hi,

I have a bug to report which happend while editing a package.

I have modified the body of a package which has previously compiled successful.
After the modification, while compiling the package this error was displayed for the header of the package:

Compilation errors for PACKAGE ELMOS_FEMES.CHECKLIST_ACTION

Error: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

in out
... long double ref char time timestamp interval date binary
national character nchar
Line: 22

The lines didn't contain any visible error:

20 PROCEDURE add_new_file(IN_ORIGIN_TYPE IN VARCHAR2,
21 IN_ORIGIN_ID IN NUMBER,
22 IN_TITLE IN VARCHAR2,
23 IN_FILE_NAME IN VARCHAR2,
24 IN_FILE_PATH IN VARCHAR2,
25 IN_MIME_TYPE IN VARCHAR2,
26 IN_SHA512_HASH IN VARCHAR2,
27 IN_WHO IN VARCHAR2,
28 OUT_DATA OUT VARCHAR2);

Meanwhile the base pck file only contains the head till line 22 and the complete body:

CREATE OR REPLACE PACKAGE CHECKLIST_ACTION AS
/**********************************************
* add_new_file
**********************************************/
PROCEDURE add_new_file(IN_ORIGIN_TYPE IN VARCHAR2,
IN_ORIGIN_ID IN NUMBER,
IN_TITLE
/
CREATE OR REPLACE PACKAGE BODY CHECKLIST_ACTION IS

/**********************************************
* add_new_file
**********************************************/
PROCEDURE add_new_file(IN_ORIGIN_TYPE IN VARCHAR2,
IN_ORIGIN_ID IN NUMBER,
IN_TITLE IN VARCHAR2,
IN_FILE_NAME IN VARCHAR2,
IN_FILE_PATH IN VARCHAR2,
IN_MIME_TYPE IN VARCHAR2,
IN_SHA512_HASH IN VARCHAR2,
IN_WHO IN VARCHAR2,
OUT_DATA OUT VARCHAR2) IS
...

The installed package on the databse is similar, the body is complete, the header has only the first 22 lines

In the developer the complete header is still visible, but when using Ctrl-A + Ctrl-C + Ctrl-V into another editor only the first 22 lines are copied.

This is the second time that I encountered this bug, first occurence was a few weeks ago.

I am using Version 12.0.5.1828 32bit
Win 7 Ultim. 64bit

I hope you can help me!

Best regards

Philipp Kopp
Elmos Semiconductor AG

 

[Marco Kalter]

I think there is a 0-character somewhere in the file. Can you open the file in a binary/hex editor, search for a 0-character, remove it (or replace it by a space), and try again?

 

[phko]

Hi,
the 0-character has to be generated somewhere in the cache of the developer.
In the local file everything after "IN_TITLE" is missing, so replacing the character in the file won't restore any missing data.

Another thing I encountered while investigating the error:
If I copy the whole header into a text editor only the first 22 lines are copied, but if I instead copy it into my mailclient the whole header is inserted including the deveolpers colors (red comments/blue text/green keywords).
So in some form the text is still available in the developer.

Philipp Kopp