| Pregunta: | 35984 - ERROR ORA-00600 |
| Autor: | Nacho |
| Al realizar la sentencia:
SELECT * FROM (SELECT SECUENCIA, COD_ENTIDAD, COD_PROCESO, COD_USUARIO, FECHA_LOG, ACTIVIDAD, TEXTO, NIVEL_LOG FROM LOG_PROC WHERE COD_ENTIDAD = 1425 AND COD_PROCESO = \'OPE\' AND SECUENCIA < 64006 ORDER BY FECHA_LOG DESC) WHERE ROWNUM < 501 Oracle retorna (no siempre, parace aleatorio): [Microsoft][ODBC driver for Oracle][Oracle]ORA-00600: código de error interno, argumentos: [srdmer_1], [650756116], [3], [], [], [], [], [] Alguien me puede dar una pista sobre este Error. Gracias de antemano. | |
| Respuesta: | Alixandro Florian |
| Sr. Nacho,
No se Si esto le ayude; es el significado del error segun el libro de errores de oracle8i. ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: * timeouts * file corruption * failed data checks in memory * hardware, memory, or I/O errors * incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Customer Support after gathering the following information: * events that led up to the error * the operations that were attempted that led to the error * the conditions of the operating system and databases at the time of the error * any unusual circumstances that occurred before receiving the ORA-00600 message * contents of any trace files generated by the error * the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error. Ademas a mi tambien me ha dado este error cuando hago una consulta de todos los datatos de una tabla por medio a una forma, esto es cuando hago una modificacion de algun campo y al intentar moverme al proximo registro sin antes grabar me pregunta si deseo grabar los cambios y le digo que SI, entonces me da el error ORA-00600. Entoces cierro la forma y la abro de nuevo y hago los mismos pasos y todo pasa bien. | |
| Respuesta: | Alixandro Florian |
| Sr. Nacho,
Hice una conculta slq similar a la que enviate y me funciono perfectamente: select * from (select compania,articulo,almacen,existencia from inventario.existencia where compania = '01' and division = '001' and almacen = '001' order by articulo desc) a where rownum >= 1 SQL> / CO ARTICULO ALM EXISTENCIA -- --------------- --- ---------- 01 VHSHFSTEREO 001 9985 01 VHS 001 9995 01 TVCP-29FA40 001 9991 01 TV29FA40 001 9989 01 TV-2520 001 258 01 SWT-50B3P 001 188 01 MICROONDA 001 9997 01 MCRF216 001 9949 01 MCF577 001 9989 01 MCCD962 001 19990 01 DVD 001 9921 01 CD700M 001 724 01 BOM26W 001 898 01 419308222502480 001 9871 01 2299900119587 001 984 01 000000000000001 001 9953 16 rows selected. SQL> Verifica la sintaxis de le tuyo. | |