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 | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    problems with connection pool in SJSAS 9

    Oracle Community | 10 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

    MyBatis Error Calling Oracle Function

    Stack Overflow | 1 year ago | greyfox
    java.sql.SQLException: Malformed SQL92 string at position: 15. Expecting "call"
  6. 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
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