Hi,
What actually causes an ORA-02289: sequence does not exist error ?
Im not authorized to post the actual codes here in this forum . But i can explain you the way the code flown and error occured.
Example:-
Declare
--
Begin
package_pkg1.proc_check(a ,b,c);
end;
and in the calling package(procedure) only i have the 20 to 30 sequences....
Also note that the the package specification and body is in compiled state(Valid).
So in this case, what action should i take first ?
Database Version : 12C