1. Javier Iglesias Prieto
  2. PowerBuilder
  3. Thursday, 16 May 2024 06:02 AM UTC

 

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:

 

  1. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.19.0.0.0
  2. 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

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 May 2024 14:33 PM UTC
  2. PowerBuilder
  3. # 1

Hi Javier;

  FYI:  https://docs.oracle.com/en/error-help/db/ora-00933/?r=23ai

I suspect that the issue is in the use of double quotes vs single quotes for data value ...

TABLE_NAME = ''DD/MM/YYYY''   =>  TABLE_NAME = 'DD/MM/YYYY'

I would check your PB IDE's DB Profile settings on the use of quotes.

Regards .. Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.