Discussions tagged Oracle

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...
Hi, I am getting database connection timeouts on a PowerServer 2020 web application even when in use (not idle).  Seems to be after several minutes.   The app will automatically reconnect to the Oracle 12c database but the fallout is that the sessio...
Hi, an error occurred while attempting to call PL/SQL Oracle procedure with string array as parameter using Oracle 19 server. Tried to install Oracle 19 client and set PBNewSPInvocation='Yes' in the DBPARM connection parameter with no result. I sa...
Hello, I'm trying to create a database connection in SnapDevelop 2019 R3 (I tried in R2 also) to an Oracle database, but I get the error "ORA-12537: Network Session: End of file". It's strange because I can connect to this database in Powerbuilder w...
Hey folks, I just installed PB2019 R3, Build 2670.  Migrated an app from PB2017 R2.  The only reason for the 2019 upgrade is because we're moving to Oracle v19 databases.  Wanted to get the app migrated before the DB upgrade.  I've searched high a...
I am trying to connect the Oracle 19C DB from PB 2019 R3(Both Source and DB Painter) and also via Application exe, And I am getting the below error.   Do I need to change any settings from PB side.  SQLCA.DBMS = "ORA Oracle" - connecting using this ...
Hi.I am converting our application from PB2017 R3 to PB2019 R3. All runs fine.Except I have a problem concerning the new runtime environement and loading Oracle oci.dll with our application.My application is named "buisy" and I would like to provide ...
Hello, since I migrated an old app developped with PB 7 to PB 2019, I have a big problem with some SQL queries from my Datawindows when executed on a database under Oracle 11g. I get this message : 1722 - select Error : SQLstate = 22005.  But the s...
  • Page :
  • 1