java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'ECON.COMMON' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Oracle Community | 807581 | 9 years ago
  1. 0

    problems with connection pool in SJSAS 9

    Oracle Community | 9 years ago | 807581
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'ECON.COMMON' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  2. 0

    OIM - Error while acessing User Profile History report

    Oracle Community | 7 years ago | kIDMan
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XL_SP_USERPROFILEHISTORY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    Ghost index calling oracle function

    Stack Overflow | 3 years ago | Alvaro Gomez
    java.sql.SQLException: Falta el parámetro IN o OUT en el índice:: 2
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Groovy Sql.execute() with sql statement as string variable not working

    Stack Overflow | 4 years ago | jwest
    java.sql.SQLException: Invalid SQL type: sqlKind = 0
  6. 0

    Oracle enterprise manager 11g - Internal Error ... | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLException: ORA-20101: Metric PhysAddress for target type netapp_filer not configured ORA-06512: at "SYSMAN.ECM_CT", line 718 ORA-06512: at line 1 ORA-06512: at "SYSMAN.EMD_LOADER", line 4931 ORA-06512: at line 1

  1. balintn 11 times, last 2 months ago
  2. Cafecanudo 2 times, last 3 months ago
18 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-06550: line 1, column 7: PLS-00201: identifier 'ECON.COMMON' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    8. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:944)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)
    12. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3856)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1373)
    13 frames
  3. testbean
    TestBean.login
    1. testbean.TestBean.login(TestBean.java:115)
    1 frame
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  5. com.sun.enterprise
    EJBSecurityManager.runMethod
    1. com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
    1 frame
  6. Security Core Classes
    SecurityUtil.invoke
    1. com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
    1 frame
  7. Embedded GlassFish Web
    EJBObjectInvocationHandler.invoke
    1. com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
    2. com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
    3. com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:203)
    4. com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:120)
    4 frames
  8. Unknown
    $Proxy83.login
    1. $Proxy83.login(Unknown Source)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  10. glassfish-corba-orb
    CorbaMessageMediatorImpl.doWork
    1. com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:154)
    2. com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:687)
    3. com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:227)
    4. com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1846)
    5. com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1706)
    6. com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:1088)
    7. com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:223)
    8. com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:806)
    9. com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:563)
    10. com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2567)
    10 frames
  11. glassfish-corba-orbgeneric
    ThreadPoolImpl$WorkerThread.run
    1. com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555)
    1 frame