Hi Chris,

When we login in we get connected ok to the database or at least no errors show up.

Right after we login I put in this and get the results below:

// login worked
messagebox("connected - sql code",  string(sqlca.sqlcode) + sqlca.sqlerrtext)
messagebox("connected - sql DB code",  string(sqlca.sqldbcode) + sqlca.sqlerrtext)

select count(*)
 into :ll_cnt
 from ediview.ediview_license;
 
messagebox("get license records - sql code", string(sqlca.sqlcode) + sqlca.sqlerrtext)

Have you applied the latest MR # 1915, which adds support for Oracle 19c to PowerBuilder 2017 R3?

Yes we have.

Hi Tim;

  Can you tell us ...

1) Are you using the native Oracle connection mechanism from the PB IDE and/or your PB App EXE?

2) Have you tried executing the SQL in the IDE's DB Painter via the iSQL pane?

Regards ... Chris

Our current situation is we do have PB17 R3.

Our client wanted to test Oracle 19C which we haven't even installed yet.

We sent them a version of PB17 R3 to test if they can connect to Oracle 19C. They do have the latest dll that came with R3.

Not the ideal situation but they were very curious if they could get it running so we obliged.

We will be installing 19C and testing next week.

We now have this working using DBMS=O90 and 19C

Not sure why but so far users are ok.

Hi Tim;

  Oracle 18C & 19C are only just "officially" supported in the latest Maintenance Release for PB 2017 R3 (build 1915) and PB 2019 build 2170.

Regards ... Chris