Discussions tagged Oracle

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. ...
Hi, We have started looking into the possibilities on using PowerServer for our main PowerBuilder application.The first steps to build the powerserver application has been successful. We are using the latest Powerbuilder 2022-version, connected to ...
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 "...
Hi, We are Evaluating PB2022 for Procuring Licenses.  Installed and migrated our application to 2022. (Train Trying to make Power Server App.  Our Database is Oracle. (Down loaded the drivers when asked and installed) We are facing the issue aft...
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...
Hi All,   I am using PowerBuilder 2019R2 build 2353 and Oracle 19C.  Recently we upgrade our database from Oracle 12 to 19.   I have procedure which OUT parameter is date table type. before database migration its return proper value in PB's dateti...
We have a client that made a simple change to a datawindow. They changed a column in the select from CAST(col1 AS CHAR(10)) to TO_CHAR(col1). They then used the C# Conversion tool in SnapDevelop 2021 to import this change into the API which was succe...
When trying to run a PowerServer application using PB 2021 Build 1288, I am getting the following error when trying to connect to the Oracle database: PB application execution Error (R0222)  Error: Session not created. Please create a session using...
  • Page :
  • 1