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