Oracle Sql Error Code 2112
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Oracle 2112 error Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-26-2000,11:35 AM #1 anandg View Profile View Forum Posts Junior Member Join Date Oct 2000 Posts 1 Hi, I am getting SQL 2112 error when executing the Pro*C++ code. The problem is random, even when there is only one matching row for the query , this error is reported sometimes i find ORA 1306 occuring just before this error. we are using oracle 7.3.4.4 on HP UX 10.20. I would like to Know that this issue is OS Specific or Database specific. Any patches need to be installed. Could you guys can throw some light. Regards, Anand.G Reply With Quote 10-27-2000,02:41 PM #2 mber View Profile View Forum Posts Member Join Date Oct 2000 Posts 123 The error is because in SELECT ... INTO returns too many rows. Cause: A SELECT ... INTO statement returned more rows than can be stored in the host variable provided. Action: There are three possible solutions: Use the precompiler option SELECT_ERROR=NO. Declare a host variable with a larger array dimension. Declare a cursor or cursor variable for the select statement. Reply With Quote Quick Navigation Forum Archives Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is Off Smilies are Off [IMG] code is Off [VIDEO] code is Off HTML code is Off Forum Rules Contact Us DBAsupport.com Home Page Top Click Here to Expand
to ORA-00899ORA-00900 to ORA-01499ORA-01500 to ORA-02099ORA-02100 to ORA-04099ORA-04100 to http://www.dbasupport.com/forums/showthread.php?3608-Oracle-2112-error ORA-07499ORA-07500 to ORA-09857ORA-09858 to ORA-12299ORA-12300 to http://iderror.com/tag/oracle-sql-error-2112-on-sum/ ORA-12399ORA-12400 to ORA-12699ORA-12700 to ORA-19399ORA-19400 to ORA-24279ORA-24280 to ORA-29249ORA-29250 to ORA-32799ORA-32800 to ORA-32999ORA-33000 to ORA-65535ORADB-AMDORADB-AUDORADB-DBVORADB-DRGORADB-EPCORADB-EXPORADB-IMGORADB-IMPORADB-KUPORADB-LCDORADB-LFIORADB-LPXORADB-LRMORADB-LSXORADB-MODORADB-NCRORADB-NIDORADB-NMPORADB-NNCORADB-NNFORADB-NNLORADB-NNOORADB-NPLORADB-NZEORADB-O2FORADB-O2IORADB-O2UORADB-PCBORADB-PCCORADB-PLSORADB-QSMORADB-RMANORADB-SQLORADB-TNSORADB-VIDWeblogic 10.3WL103-ApiWL103-ApplicationPollerWL103-BridgeWL103-BugReporterWL103-CacheWL103-ClusterWL103-ClusterExtensionWL103-CommonWL103-ConfigWL103-ConnectorWL103-ConsoleServicesWL103-CustomModuleWL103-DatabaseLessLeasingWL103-DebugModuleWL103-DeployerRuntimeWL103-DeploymentManagerWL103-DeploymentServiceWL103-DiagnosticsWL103-DiagnosticsHarvesterWL103-DiagnosticsInstrumentorWL103-DiagnosticsWatchWL103-DRSWL103-EJBWL103-EngineWL103-EntitlementWL103-FastSwapWL103-HarvesterJMXWL103-HealthWL103-HTTPWL103-HTTPSessionWL103-IIOPWL103-JDBCWL103-JMSWL103-JMSClientExceptionWL103-JMSExceptionWL103-JMXWL103-JNDIWL103-KernelWL103-LogMgmtWL103-ManagementWL103-MasterDeployerWL103-MBeanTypingUtilWL103-MessagingWL103-MIExceptionWL103-NetWL103-NodeManagerWL103-PathWL103-PubSubWL103-PubSubJmsWL103-RMIWL103-SAFWL103-SecurityWL103-ServerWL103-ServiceWL103-SingletonWL103-SlaveDeployerWL103-SNMPWL103-SocketWL103-SPIDeployerWL103-StoreWL103-T3MiscWL103-T3SrvrWL103-TXWL103-TXExceptionWL103-WebServiceWL103-WLSConsoleWL103-WorkManagerWL103-WTCWL103-XMLWebLogic 9.2WL92-ApplicationPollerWL92-BridgeWL92-BugReporterWL92-ClusterWL92-CommonWL92-ConfigWL92-ConnectorWL92-ConsoleServicesWL92-CustomModuleWL92-DeployerRuntimeWL92-DeploymentManagerWL92-DeploymentServiceWL92-DiagnosticsWL92-DRSWL92-EJBWL92-EntitlementWL92-Heal
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and Development https://docs.oracle.com/cd/A97688_16/toplink.903/b10068/errorcod.htm Exceptions" for more information. Format: A description shown in the actual https://www.ibm.com/support/knowledgecenter/SS6NHC/com.ibm.swg.im.dashdb.apdv.plsql.doc/doc/r0055262.html exception thrown. Cause: The most probable cause for the error. Action: Suggestions for resolving the error. Descriptor Exceptions (1 - 176) Error code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause: