PowerBuilder pipeline issue connected to Oracle 11g using the O10
Oracle10g (10.1.0) DB interface
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.
Solution
Use the ORA PowerBuilder database interface to connect to Oracle
11g to use unicode datatypes.
SQLCA.DBMS = “ORA Oracle”