1 Reply Latest reply: Oct 21, 2013 3:24 AM by 3e445c4f-d1fb-4826-88d4-405ce163ca6f RSS

    SQLAuthenticator Provider Specific ORA-01722 invalid number error

    951671
      Hi dears,

      I'm using WLS 10.3 and JDev 11.1.1.6 and trying to create a new Authenticator in security realm called "myrealm". This auth. is a sql authenticator and it is used for logging on webcenter applications with my own user table.

      In the provider specific tab i organized the SQL expressions according to my user table. When i restart the IWLS, an exception has been thrown : ORA-01722 invalid number error

      Error Details :
      (<Nov 9, 2012 2:42:34 PM EET> <Error> <Security> <BEA-000000> <[Security:090759]A SQLException occurred while retrieving password information
      java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
           Truncated. see log file for complete stacktrace
      >
      <Nov 9, 2012 2:42:34 PM EET> <Error> <Security> <BEA-000000> <[Security:090759]A SQLException occurred while retrieving user information
      java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
           Truncated. see log file for complete stacktrace
      )

      Does anybody help me about this problem?

      Thx in advance,
      Erdo