1. René Ullrich
  2. PowerBuilder
  3. Wednesday, 17 October 2018 12:45 PM



Oracle 12 supports identity columns with new GENERATED AS IDENTITY clause.

I've tried to get it work with PowerBuilder Datawindows (using ORA driver). I specified the identity columns in the datawindow update properties dialog. But I can't get it to work. PowerBuilder doesn't gets the generated value from oracle.


Does Powerbuilder supports identity columns with Oracle?


Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 October 2018 13:16 PM
  2. PowerBuilder
  3. # 1

Hi René;

  Since this is new to Oracle vs being a long time feature of ASE and SS, I suspect that the ORA driver needs to be "tweaked". Normally in ASE or SS when the DWO recognizes an Identity Column (aka Auto Increment) it issues a "ReSelectRow" command behind the scenes to get the new auto assigned value by the DBMS.

  The bad news is that we probably need to open a Support Ticket for this new O12c feature to be supported. The good news is that your App's can use the ReSelectRow() command today (as a workaround) as that command has been a feature in PB for decades.


Regards ... Chris

Hi Chris,

I have not tried it but I guess ReSelectRow would not work. PB can't create the where clause to find the row because it doesn't know the values of the primary key column.
  1. René Ullrich
  2. Wednesday, 17 October 2018 13:24 PM
Correct .. so set the Update properties to Identity = None. Then use the ReSelectRow.approach
  1. Chris Pollach @Appeon
  2. Wednesday, 17 October 2018 14:33 PM
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.