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.