Environment: pb12.5, Windows 7 x86, oracle11g create data window times wrong

Select a table in the table selection box times wrong

Ora - 00936 error expression

Please support guidance!

CodePudding user response:

The

refer to the original poster PHDYCN response:

environment: pb12.5, Windows 7 x86, oracle11g create data window times wrong

Select a table in the table selection box times wrong

Ora - 00936 error expression

Please support guidance!

Ora - 00936 for expression error, if you choose a table is wrong, should be a connection configuration has a problem, carefully check the database connection

If the operating system is 64, oracle11g don't install 64 - bit, 32-bit is loaded

CodePudding user response:

Will be a database, an error and is not an error table comparison found that differences in: an error in the table has a timestamp field.

SQL code in the data window interface through the select select timestamp field when the data window cannot be saved.

Its basic reason in PB12.5 data window read timestamp field error.

Please expert guidance!!!!!!!!!!

CodePudding user response:

Linux server installation oracle11g
Development environment: Windows 7 32 bit, PB 12.5, no client install oracle 11 g. PB used to own 10 g. An error after 11 g 32-bit client installation

CodePudding user response:

The field need not added to the data window

CodePudding user response:

Test found in the oracle database table called ZW_TEST_TS field 1: CF_FID (varchar2) field 2: CF_TS (timestamp (6)) when pb selection error, error prompt expression.

Table and the same field called ZW_TEST is not an error. You can choose to but can't choose cf_ts.

Isn't about the naming and table, use more than one _?