java.sql.SQLException: ORA-01436: CONNECT BY loop in user data

Oracle Community | GVC_OIM | 3 years ago
  1. 0

    Is there a way where we can set the headers from custom plugin

    Oracle Community | 4 years ago | abhay kumar
    java.sql.SQLException: ORA-01465: invalid hex number
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    java.sql.SQLException: SQL string is not Query

    Oracle Community | 4 years ago | user10313574
    java.sql.SQLException: SQL string is not Query
  4. 0

    Passing complete sql query as a parameter to dataset in report

    Stack Overflow | 3 years ago | Bhaskar
    java.sql.SQLException: SQL string is not Query

  1. qavid 1 times, last 5 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-01436: CONNECT BY loop in user data

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. oracle.iam.identity
    UserManagerProviderImpl.isUserManagerOf
    1. oracle.iam.identity.usermgmt.internal.impl.UserManagerInternalImpl.isUserManagerOf(UserManagerInternalImpl.java:95)
    2. oracle.iam.identity.usermgmt.impl.UserManagerProviderImpl.isUserManagerOf(UserManagerProviderImpl.java:59)
    2 frames
  5. oracle.iam.platform
    AuthorizationServiceImpl.hasAccess
    1. oracle.iam.platform.authz.vo.InternalObligation.validate(InternalObligation.java:266)
    2. oracle.iam.platform.authz.impl.OESAuthzServiceImpl.doCheckAccess(OESAuthzServiceImpl.java:241)
    3. oracle.iam.platform.authz.impl.OESAuthzServiceImpl.hasAccess(OESAuthzServiceImpl.java:187)
    4. oracle.iam.platform.authz.impl.AuthorizationServiceImpl.hasAccess(AuthorizationServiceImpl.java:185)
    4 frames
  6. oracle.iam.identity
    UserManagerEJB.getDetailsx
    1. oracle.iam.identity.usermgmt.utils.UserManagerUtils.getAuthorizedLookupableAttrs(UserManagerUtils.java:150)
    2. oracle.iam.identity.usermgmt.impl.UserManagerImpl.getDetails(UserManagerImpl.java:1556)
    3. oracle.iam.identity.usermgmt.api.UserManagerEJB.getDetailsx(Unknown Source)
    3 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor3304.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames