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