I have created a Package on a test server using oracle 10g em.
I'd like to move to update an existing package on a linux server with this new code.
Therefore I opened it in EM, listed the sql code EM would execute in order to update in on its server and pasted it into the sqlplus command line, but it only shows up weird results.
The code is something link:
CREATE OR REPLACE PACKAGE BODY PACKAGENAME IS
-- PL/SQL Block
/* Constant Declaration */
Please also let me know how I can check if the code was updated correctly.