When I called sqlplus using cron schedule job in unix, the following error occurred:
SP2-0642: SQL*Plus internal error state 2165, context 1804:0:0
Unable to proceed
SQL*Plus: Release 22.214.171.124.0 - Production on Sat Nov 8 03:40:03 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Is this sqlplus error or because of oracle 126.96.36.199.0 ? Do I need to patch this database? If so, where can I get the patch?
Thank you very much!
Its likely to be an environment problem - especially if using cron - make sure your script exports $ORACLE_HOME, $ORACLE_SID and also has $ORACLE_HOME/bin in its $PATH.