SQL & PL/SQL

Hi all,

We are having an application in C# and backend oracle 10g placed in Location1.

There is modification in Packaged procedure. So we remotely (from Location2) connected to Location1 and that Packaged procedure is created.

This Packaged procedure has been created (in Location1 ) without any errors. But this procedure is in INVALID state. We tried to compile it remotely by using following statements, but still this is in invalid state .

ALTER PACKAGE my_package COMPILE;
ALTER PACKAGE my_package COMPILE BODY;

If we run this package and package body manually, without any modifications after creating it remotly, it is becoming VALID state.

I am not getting any idea, why it is creating in INVALID state. Any help is appreciated.

Thanks in advance,
Pal