"Change window to" ... "SQL Window"

Benjamin L

Member²
PSD 12.0.4.1826 (64 Bit)
When changing windows, from Program Window to SQL window, there is a 3F character added at the beginning.

i created a package with program window and this code
create or replace package tmp_test is

PROCEDURE tmp_start;

end tmp_test;
/
create or replace package body tmp_test is

PROCEDURE tmp_start IS
BEGIN
NULL;
END;

end tmp_test;
/
... after switching the package code to sql window, a 3F-character is added at the beginning and compiling results in a ORA-00911

Best regards
Benjamin

 
Last edited:
Does the program window indeed contain the slashes? The specification and body should be placed in 2 separate tabs.
 
No it doesn't, it is placed in 2 seperate tabs.
I pasted this just as sample code, because i have no idea how to paste a program window here in the forum ;)
 
I cannot immediately reproduce this. It seems to work fine. Can you send me the exact program file? Maybe there is something hidden in there that is lost when copying it to the forum post.
 
The test file does not immediately reproduce the issue, but I see that it has a Unicode header (UTF8 BOM). The resulting file you sent has a double Unicode header, which is incorrect and causes the problem.

Can you let me know your Files > Format / Encoding options from the preferences?
 
Back
Top