PB application goes hang when trying to connect with Oracle12 (EXADATA)

[Former Member]

Hi Everyone,

I am using Power Builder Classic (PB 11.1 build 8123). Right now my organization upgrade the oracle DB from 11 to 12C. After upgrade the DB, mostly all windows goes hang when we try to populate the detail. After that, need to close the application forcibly. Its working fine with Oracle 11.

My DB connection syntax is:-

// Profile

SQLCA.DBMS = "O10 Oracle10g"

SQLCA.LogPass = "*********"

SQLCA.ServerName = "xxxx"

SQLCA.LogId = "xxxxx"

SQLCA.AutoCommit = False

SQLCA.DBParm = "PBDBMS=0,SQLCache=8,Delimitidentifier='no',StaticBind=0, DisableBind=1"

Please suggest.

Thanks,

Vikrant

[former_member190719]

Not sure it helps much but all of our PowerBuilder apps worked fine when the database was moved to 12.

I'd also recommend looking at those DBParm parameters.  We're not using any of them.

[Former Member]

Start by removing the PBDBMS dbparm. That parameter was used in Oracle 7.x days.

What Oracle client are you using?

[Former Member]

Hi Kiran;

FYI: Oracle 12c compliance was not released until PB v12.6 .... Support for Using PowerBuilder and Oracle - SAP PowerBuilder - SCN Wiki

HTH

Regards ... Chris

[Former Member]

Hi

I think you need to eliminate an issue at the database layer before trying to find a problem with PB.

What SQL is being fired by PB, does this SQL work in Toad or other external tool?

Cheers

David