Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jul 27, 2016 at 10:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 04:15 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 12:34 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 02:54 PM

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

    What Oracle client are you using?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.