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
------------------------------

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
------------------------------

Original Message:
Sent: Wed January 25, 2023 06:44 AM
From: Mikael Lindblad
Subject: Bug? OAuth token clean-up

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
------------------------------