Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

 ORA-01003: no statement parsedbases_datos_2

 


 

Cause: A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE, and FETCH.

 

Action: Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00912: input parameter too longbases_datos_2

 


 

Cause: one of your input strings was too long

 

Action: shorten the input parameter length

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00953: missing or invalid index namebases_datos_2

 


 

Cause: An index name of the form [ <identifier> . ] <identifier> is expected but not present. If OIDINDEX clause, index name must be <identifier>

 

Action: Enter an appropriate index name.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00960: ambiguous column naming in select listbases_datos_2

 


 

Cause: A column name in the order-by list matches more than one select list columns.

 

Action: Remove duplicate column naming in select list.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00962: too many group-by / order-by expressionsbases_datos_2

 


 

Cause: The group-by or order-by column list contain more than 1000 expressions.

 

Action: Use 1000 or less expressions in the group-by or order-by list.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00964: table name not in FROM listbases_datos_2

 


 

Cause: The table name referred in the select list is not specified in the from list.

 

Action: Make sure the name is correctly specified and matches one of the names in the from list.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00965: column aliases not allowed for '*'bases_datos_2

 


 

Cause: The statement is trying to alias the * expression in the select list which is not legal.

 

Action: Remove the alias.