We have a datastore using an Oracle Stored Procedure Update. For the insert stored proc, one of the columns is mapped to an output argument, to capture the new transaction sequence ID generated by the stored procedure. Client Server app correctly pop...

We recently migrated a PB 2019 application to 2022 and also deployed it to PowerServer.  It's been working very well.  However, one user reported an issue recently.  The user stated that the app was started and used without issue for a while.  It was...

Hello everyone.  I need help, I have a powerbuilder 2022 and it is mounted on a server with windows server 2019, all my projects are set to run on power server and use an IIS server to publish it, so far everything works fine but, when my users star...

I've been attempting to utilize an Oracle Stored Procedure in a DataWindow to retrieve data, however upon retrieval I receive the following error. ORA-06550 - Identifier '{indentifier}' must be declared. The issue can be created in the DW painter. ...

Good afternon. Please, how do I add an new option ORACLE 12 in my list "INSTALLED DATABASE INTERFACES"? My powerbuilder is 2022 and I have oracle cliente 12.1. Today I use connected with option "O10 Oracle 10g", but we are going to migrate for orac...

hello friends, I have a project in powerbuilder that was originally in PB 12.5, this project was migrated to PB 2021, everything works fine but when generating a pdf from datawindow it generates a file with a weight of KB, I solved this by checking "...

Using PB2022 Beta I was able to take our existing client/server app and create a working PowerServer project.  However, after I uninstalled the Beta and installed PB2022 build 1878, the web version no longer works.  Trying a Build/Deploy gives the er...

Hi, I am getting a powerserver error when I am updating a datawindow with a package stored procedure in Oracle 19. My Powerbuilder version is: Appeon Powerbuilder 2021 CloudPro Edition. Database is Oracle19 64 bit. When I am updating a datawindow...

Hi, I need suggestion for below case. We are doing application server migration from HP-UX to RHEL. Our application client we used for PowerBuilder 2017 and Server side logic we written in Oracle Tuxedo. So ,now data the communication between clien...

After upgrading Oracle Database to version 19c - we have an issue, a runtime failure when a stored procedure with an input parameter of a table type or an array is being called from the PBL. Power Builder: Version 2019 R2 Build 2353 Oracle Database...

Hi all. Apologies for resurrecting this question, I thought I had discovered the answer but no luck. We have an odd error occurring in an app built in Powerbuilder after an Oracle 19c upgrade. I am wondering if anyone else has seen this. Anytime the...

Hello everybody,I'm testing my PB Client / Server application (PB2021) compiled with PowerServer2021. The data server is Oracle 12c. The application makes use of calls to Oracle StoredProcedure (PL/SQL) and in the PowerServer version I have some pro...

We have a PB classic application migrating to PS (latest PB etc.), connecting to Oracle 19 database.  When the application runs in PS it is not encapsulating multiple SQL statements in a transaction, almost as though a commit is issued between each s...

Challenge we have The DB Connections are pooled by IIS, Oracle 19c as BACKEND and we would not able to capture the OS USER ID for Auditing the actions. Audit of user actions are captured using bcakend triggers and user name is used as "OS USER", si...

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 m...