The sense of praise that I have found for you after reading Oracle HRMS Interview Questions and answers is overwhelming! Such a tremendous read! I am executing one package from Linux shell script.This will invoke JAVA application, from that Database procedure will gets executed.
But when I am running continuously the same job, some time following error is coming ,but some time it executing successfully.
When I am running the same procedure complete from the DATABASE, always its executing successfully.
Unable to find out under which scenarios,existing STATE OF PACKAGE is becoming INVALIDATE
ORA-04061: existing state of package "MAIN.PKG_ABCD_XYZ_HANDOFF" has been invalidated ORA-04065: not executed, altered or dropped package "MAIN.PKG_ABCD_XYZ_HANDOFF" ORA-06508: PL/SQL: could not find program unit being called: "MAIN.PKG_ABCD_XYZ_HANDOFF"
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
The sense of praise that I have found for you after reading Oracle HRMS Interview Questions and answers is overwhelming! Such a tremendous read! I am executing one package from Linux shell script .This will invoke JAVA application, from that Database procedure will gets executed.
But when I am running continuously the same job, some time following error is coming ,but some time it executing successfully.
When I am running the same procedure complete from the DATABASE, always its executing successfully.
Unable to find out under which scenarios,existing STATE OF PACKAGE is becoming INVALIDATE
ORA-04061: existing state of package "MAIN.PKG_ABCD_XYZ_HANDOFF" has been invalidated ORA-04065: not executed, altered or dropped package "MAIN.PKG_ABCD_XYZ_HANDOFF" ORA-06508: PL/SQL: could not find program unit being called: "MAIN.PKG_ABCD_XYZ_HANDOFF"
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Hello There,
ReplyDeleteThe sense of praise that I have found for you after reading Oracle HRMS Interview Questions and answers is overwhelming! Such a tremendous read!
I am executing one package from Linux shell script.This will invoke JAVA application, from that Database procedure will gets executed.
But when I am running continuously the same job, some time following error is coming ,but
some time it executing successfully.
When I am running the same procedure complete from the DATABASE, always its executing successfully.
Unable to find out under which scenarios,existing STATE OF PACKAGE is becoming INVALIDATE
ORA-04061: existing state of package "MAIN.PKG_ABCD_XYZ_HANDOFF" has been invalidated
ORA-04065: not executed, altered or dropped package "MAIN.PKG_ABCD_XYZ_HANDOFF"
ORA-06508: PL/SQL: could not find program unit being called: "MAIN.PKG_ABCD_XYZ_HANDOFF"
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Best Regards,
Preethi
Hello Mate,
ReplyDeleteThe sense of praise that I have found for you after reading Oracle HRMS Interview Questions and answers is overwhelming! Such a tremendous read!
I am executing one package from Linux shell script .This will invoke JAVA application, from that Database procedure will gets executed.
But when I am running continuously the same job, some time following error is coming ,but
some time it executing successfully.
When I am running the same procedure complete from the DATABASE, always its executing successfully.
Unable to find out under which scenarios,existing STATE OF PACKAGE is becoming INVALIDATE
ORA-04061: existing state of package "MAIN.PKG_ABCD_XYZ_HANDOFF" has been invalidated
ORA-04065: not executed, altered or dropped package "MAIN.PKG_ABCD_XYZ_HANDOFF"
ORA-06508: PL/SQL: could not find program unit being called: "MAIN.PKG_ABCD_XYZ_HANDOFF"
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Best Regards,
Radhey
Hello There,
ReplyDelete11/10!! Your blog is such a complete read. I like your approach with Being arjoon... . Clearly, you wrote it to make learning a cake walk for me.
how to find first nonspace character from end of the string
ex: 'abc def g '
I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.
Could you help me in getting this?
I am so grateful for your blog. Really looking forward to read more.
Best Regards,
Preethi.