Program Window Compile problem

[mike]

I have version 8.0.4.1514.

If I compile this code using the program window, the ampersand is missing in the compiled code. It does not happen if I compile it using the Command window. I tried disabling all of my plug-ins and removing my login.sql and afterconnect.sql scripts.

A co-worker has the same version of PL/SQL Developer, and he can compile this code correctly on the same database. So, I'm thinking it could be a preference, but so far, I haven't figured it out. Any ideas?

CREATE OR REPLACE PACKAGE zper_apple AUTHID DEFINER AS
   PROCEDURE main;
END zper_apple;
/
CREATE OR REPLACE PACKAGE BODY zper_apple AS
   c_ohsu_gre CONSTANT VARCHAR(34) := 'Oregon Health & Science University';

   PROCEDURE main IS
   BEGIN
      NULL;
   END main;
END zper_apple;
/

 

[Marco Kalter]

I cannot reproduce this in the Program Window. Can you go to Tools > Preferences > Oracle / Compiler and check if you have any substitution variable declared?

 

[mike]

HaHa, that was it! I had a blank row in the substitution variables preference. I deleted it and now it's fixed.

Thanks for your help,

Mike

 

[Marco Kalter]

Thanks for letting me know. This is not intended behavior, so we'll fix it.

 

[darren]

Hi,

Just wondering if this was ever fixed? I had the same issue; somehow I had ended up with a blank row in my substitution variables (with hilarious consequences - ie breaking one of our live systems, due to a missing ampersand in a package I'd compiled).

I'm currently using v9.0.6.1665 and still seem able to generate blank rows in this section, if I deliberately try to do so. Given the potential consequences of this, it would be really helpful if it wasn't allowed.

Cheers.

 

[Marco Kalter]

We'll check it out.