Compile problems

[DaveW]

Hi,
When I attempt to re-compile a package that contains ampersands (&)or (&amp) inside some of its XML processing, PL/SQL Developer pops up a window asking for input parameters. Of course there are no input parameters! (The code compiles with other tools). I have been told that I need to "set scan off" which can be done in SQLPlus, but this must be possible from within PL/SQL Developer too? Help would be appreciated! Thanks.

 

[Worker]

Sounds like the package is opening in a SQL window. This problem should not occur if the package is opened in a Program window.

Either right-click the text in the window and use Change Window to -> Program Window, or close the window and use File -> Open -> Program File.

You might also want to look at Tools -> Preferences -> Files -> Extensions, and add your file extension under Program Files -> Others.

 

[patch]

And if you want to run the code in a command window, maybe you could add 'Set Define Off' as your first command.

 

[DaveW]

Many thanks Worker and patch, I'll try these things when I'm back & work next week & report back.