Hi,
It fails when we try to open this table in the DB Painter:
Powerbuilder version: PB22 R3 Build 3289
Oracle DB Client: instantclient_19_20
DB Test:
- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.19.0.0.0
- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.23.0.0.0
CREATE TABLE "TMP_TABLE_TEST" (
"PKCOL" VARCHAR2(5) NOT NULL,
"COL1" NUMBER(7,0),
"COL2" VARCHAR2(10) DEFAULT 'dd/mm/yyyy',
"COL3" VARCHAR2(1) DEFAULT 'N'
);
In the DB trace, a query is launched to check the default value of the numeric field and in the condition of said query, it includes the default value ''dd/mm/yyyy'' in double quotes as the table name .
SELECT DATA_DEFAULT FROM USER_TAB_COLUMNS WHERE TABLE_NAME = ''DD/MM/YYYY'' AND COLUMN_NAME = 'COL1'(DBI_DEBUG_MESSAGE) (0.001 MS / 2795.950 MS)
(00EA1818): SELECT SEQS.SEQUENCE_NAME FROM USER_TABLES TABS JOIN USER_TRIGGERS TRIGS ON TRIGS.TABLE_NAME = TABS.TABLE_NAME JOIN USER_DEPENDENCIES DEPS ON DEPS.NAME = TRIGS.TRIGGER_NAME JOIN USER_SEQUENCES SEQS ON SEQS.SEQUENCE_NAME = DEPS.REFERENCED_NAME WHERE TABS.TABLE_NAME=''DD/MM/YYYY''(DBI_DEBUG_MESSAGE) (0.001 MS / 2795.951 MS)
(00EA1818): *** ERROR 933 ***(rc -1) : ORA-00933: comando SQL no terminado correctamente