Symptom

Using PowerBuilder, Oracle 11g database and SQLCA.DBMS = "O10 Oracle10g (10.1.0)" to connect to the database, the customer is unable to create pipeline objects.   The Oracle 11g tables include unicode datatypes, nchar and nvarchar2 and he cannot see them when creating the pipeline.    

  • Customer is not able to see the table columns with Oracle 11g unicode datatypes when creating a pipeline
  • If tables do not include Oracle 11g unicode datatypes, the tables are available and the pipelines work as expected.

Environment

  • PowerBuilder
  • SQLCA.DBMS = "O10 Oracle10g (10.1.0)
  • Oracle 11g database

Reproducing the Issue

  • Create an Oracle table in PowerBuilder connected with the ORA database interface, Oracle SQL Developer or another tool.  Include a column or columns with unicode datatypes, nchar and nvarchar2. 
  • Populate with test data.
  • In PowerBuilder connect to the Oracle 11g database using the O10 database interface
  • Try to create a pipeline object and choose a table having columns with unicode datatypes
  • You will initially receive an Oracle error message, ORA-00936 missing expression
  • Click OK and you see the table name but no columns 

Cause

PowerBuilder Oracle O10 database interface does not support these datatypes.

If using, SQLCA.DBMS = "O10 Oracle10g (10.1.0)", to connect to your Oracle database, you will not be able to use the Oracle 11g unicode datatypes.

Resolution

Use the ORA PowerBuilder database interface to connect to Oracle 11g to use unicode datatypes.

SQLCA.DBMS = "ORA Oracle"

2
0