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...
PowerServer 2022 Session Error/Timeout
- Issue
- Last updated 2 months ago
- Logan Liu @Appeon replied 1 month ago
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...
Disconnection problems PowerServer 2022
- Issue
- Last updated 2 months ago
- Armeen Mazda @Appeon replied 2 months ago
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...
Oracle Stored Procedure Retrieving Data
- How-to
- Last updated 2 months ago
- Miguel Leeuwe replied 2 months ago
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.
...
PowerServer and SelectBlob - Oracle
- Resolved
- How-to
- Last updated 2 months ago
- Geir Magne Vangen replied 1 month ago
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 ...
How I do connect PB 2022 with oracle 12
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
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...
generate pdf in powerbuilder 2021
- Advice
- Last updated 3 months ago
- Kim Berghall replied 3 months ago
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 "...
PowerServer2022 Web app configuration at Database throwing ORA-12514 error
- Resolved
- Issue
- Last updated 4 months ago
- Logan Liu @Appeon replied 4 months ago
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...
Could not load file or assembly 'OracleManagedDataAccess'...
- Issue
- Last updated 5 months ago
- Armeen Mazda @Appeon replied 5 months ago
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...
PowerServer error when updating datawindow with Oracle Package Stored Procedure
- Issue
- Last updated 6 months ago
- Chris Pollach @Appeon replied 6 months ago
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...
ORA-00942 error accessing tables etc in Oracle 19c
- Issue
- Last updated 8 months ago
- Walter O'Driscoll replied 9 months ago
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...
PowerServer 2021 - Issues with Oracle StoredProcedure
- Issue
- Last updated 9 months ago
- David Xiong @Appeon replied 9 months ago
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...
PowerServer not encapsulating SQL in Transactions
- Issue
- Last updated 1 year ago
- Kai Zhao @Appeon replied 1 year ago
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...
Powerserver Oracle DB Connection Audit User with OS USER
- Issue
- Last updated 1 year ago
- Jason Frost replied 1 year ago
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...
Does Oracle interface PBO10.dll work with Oracle 19c ?
- Advice
- Last updated 1 year ago
- John Fauss replied 1 year ago
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...
datetime variable doesn't working with RPC
- Resolved
- Issue
- Last updated 1 year ago
- mukul pandey replied 1 year ago
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...
SnapDevelop 2021: C# Model Converter issue
- Resolved
- Issue
- Last updated 1 year ago
- David Xiong @Appeon replied 1 year ago
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...
ConnectAndCreateTransaction with Oracle / PowerServer application
- Resolved
- How-to
- Last updated 1 year ago
- Bryant Burnard replied 1 year ago
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