IBM Security Verify

 View Only
  • 1.  Bug? OAuth token clean-up

    Posted Wed January 25, 2023 06:44 AM

    I was looking into another issue i found this in the create table script that comes with ISVA, i removed everything except the STATE_ID which cause a problem when i try to follow this guide -> OAuth token clean-up - IBM Documentation

    CREATE TABLE OAUTH20_TOKEN_CACHE (
    STATE_ID VARCHAR2(64) NOT NULL,
    );

    CREATE TABLE OAUTH20_TOKEN_EXTRA_ATTRIBUTE (
    STATE_ID VARCHAR2(256),
    );

    This sql command then fails for me

    SELECT STATE_ID as V1 FROM OAUTH20_TOKEN_CACHE WHERE OAUTH20_TOKEN_CACHE.STATE_ID = OAUTH20_TOKEN_EXTRA_ATTRIBUTE.STATE_ID

    with error ORA-00904

    Is it correct that it should state_id should have different sizes 64 and 256?





    ------------------------------
    Regards Mikael
    ------------------------------


  • 2.  RE: Bug? OAuth token clean-up

    Posted Thu January 26, 2023 02:54 AM
    HI

    having state_id with different column width shouldn't be an issue. 

    Is there further details on what you got (entire string ) with ORA-00904?

    thanks
    tushar


    ------------------------------
    Tushar
    Tushar
    ------------------------------