Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Does Oracle interface PBO10.dll work with Oracle 19c ?

  1. Advice
0
Votes
Undo
  1. sebastien lietart
    sebastien lietart
  2. PowerBuilder
  3. Wednesday, 16 February 2022 14:01 PM UTC

PB 2019 R3 build 2703

Old Database Oracle 10g

New Database Oracle 19c

 

We have to change our database application to the new Database Oracle 19 c (before it was Oracle 10g).

Does we have to change to the new Oracle interface (PBORA.dll) as it mentionned  in https://docs.appeon.com/pb2019r3/connecting_to_your_database/Using_Oracle.html#XREF_86815_ORA_driver_support ? 

Because the old interface seems to work fine too (PBO10.dll)  and i must change all my app params if i had to change to PBORA.dll ?

 

 

thanks

Sébastien

  1. Oracle
Special Characters in DW Parameter entry fields
Appeon Web Plugin - Printing Issues
Responses (2)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 16 February 2022 15:06 PM UTC
  2. PowerBuilder
  3. # 1

Do you HAVE to? Possibly not. SHOULD you? Yes.

The "O10" database interface may work with versions of Oracle later than 10, but it is not officially supported. You should use the "ORA" database interface for Oracle 11g, 12c, 18c and 19c, according to the following documentation:

https://docs.appeon.com/pb2021/connecting_to_your_database/XREF_51200_CHAPTER_10_Using.html#XREF_11471_Supported_versions

The ORA database interface was introduced in PB 11.5, circa 2008, for Oracle 11g.

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 16 February 2022 15:03 PM UTC
  2. PowerBuilder
  3. # 2

The PB database driver (PBORA.DLL or PBO10.DLL) talks to Oracle Client, not directly to the database server.

If you want to stay with O10, you also have to keep the current version of Oracle Client. This might prevent the application from using new datatypes or SQL functions.

You would be better off switching to ORA and installing the Oracle Client that is designed for Oracle 19c. I'm not an Oracle expert so I can't say for sure but I don't think you have to upgrade the PB driver and Oracle Client right away. You'll have to test that.

 

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.