Hi

I have a problem in calling a procedure.

When i call a procedure in another pl/sql block, i get an error saying the object procedure_name (i.e. name of the procedure) is in an invalid state.

whats the problem..How do I come over this.

Thanks in advance.

regards