Through this post, we highlight few points being used in oracle & application very often but still unknown....
1) ORA-0000 : normal,successful completion - For every successful transaction oracle returns ORA-0000.
2)Concurrent Programs use auto commit - If invoking same procedure from database do commit at end, to avoid different behavior as concurrent program.
3)Change profile using FA resp - sometime few profiles need cache clear to reflect the change value. Changing profile value using Functional Administrator responsibility does not require any cache clear.
4)Dummy Oracle Apps Link - mentioned url will launch the oracle application, create your login and do practice oracle apps at home
http://vis1200.solutionbeacon.
1) ORA-0000 : normal,successful completion - For every successful transaction oracle returns ORA-0000.
2)Concurrent Programs use auto commit - If invoking same procedure from database do commit at end, to avoid different behavior as concurrent program.
3)Change profile using FA resp - sometime few profiles need cache clear to reflect the change value. Changing profile value using Functional Administrator responsibility does not require any cache clear.
4)Dummy Oracle Apps Link - mentioned url will launch the oracle application, create your login and do practice oracle apps at home
http://vis1200.solutionbeacon.
No comments:
Post a Comment