Discussions tagged Oracle
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 opening Dynamic Cursor with Oracle 19c
- Resolved
- Issue
- Last updated 1 week ago
- Walter O'Driscoll replied 1 week ago
Hi all. 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. This worked absolutely fine in Oracle 12c. Here is the sanitised code snippet
ls_SqlStatement= "SELECT B...
PowerServer 2021 - Issues with Oracle StoredProcedure
- Issue
- Last updated 1 month ago
- David Xiong @Appeon replied 2 weeks 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 3 months ago
- Kai Zhao @Appeon replied 3 months 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 3 months ago
- Jason Frost replied 3 months 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 4 months ago
- John Fauss replied 4 months 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 5 months ago
- mukul pandey replied 5 months 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 5 months ago
- David Xiong @Appeon replied 5 months 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 7 months ago
- Bryant Burnard replied 7 months 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...
Timeouts occurring in PowerServer web app so Oracle session is lost.
- Resolved
- Issue
- Last updated 9 months ago
- Michael Turton replied 9 months ago
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...
"ORA-01024: invalid datatype in OCI call" oracle 19 Server, PB2019 R2 Build 2353
- Issue
- Last updated 10 months ago
- Armeen Mazda @Appeon replied 10 months ago
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...
Can't find PBORA190.dll anywhere after installation
- Resolved
- How-to
- Last updated 1 year ago
- Jim Means replied 1 year ago
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...
Error Connecting Oracle 19C DB
- Resolved
- How-to
- Last updated 1 year ago
- Danish Ahamed LiakathAli replied 1 year ago
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 ...
PB2019 R3 "OCI.DLL could not be loaded"
- How-to
- Last updated 1 year ago
- Ken Guo @Appeon replied 1 year ago
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 ...
Datawindow Retrieve Error : 1722 - select Error : SQLstate = 22005
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
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...
Datawindow, column with numbers only - null problem
- Resolved
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hello,I have column "period", i set an editmask like ### to prevent enter a non-digits characters.When I clear this column (i expected null value in table) - there is always zero.What I want to achieve: column with numbers only and null - when null t...
Too many calls to Oracle ALL_SYNONYMS view
- Issue
- Last updated 1 year ago
- René Ullrich replied 1 year ago
Is there a way to keep PB from selecting from ALL_SYNONYMS in Oracle?
May be generated by call to SyntaxFromSQL...
Hello,
is there a way to influence the binding process between SnapObjects and a database (specifically Oracle) yet?
The issue we're facing is that when reading from an Column that has the type NUMBER, SnapObjects requires the property in the C# Mo...
Oracle 19c Compatible
- Resolved
- Advice
- Last updated 1 year ago
- Narayanamoorthy Thangavel replied 1 year ago
Hi All,
Could you please help me the below two questions.
1. Actually we are using two applications and both are windows based application and developed by PowerBuilder.
One application we are using powerbuilder version 6.5 and connected to...
- Page :
- 1