Discussions tagged Oracle
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...
Hello all - I tried to search for similar postings on this issue - could not find exact match.
Our Network group is trying to upgrade to Oracle Client 19 and we are currently already migrated to Oracle 19c without any problems, with PB 2017 R2 buil...
We have migrated our web api to SnapDevelop 2.0. It runs on a Windows 10 machine using an Oracle 11g database. The api method below worked fine in SnapDevelop 1.0 but now after the migration we are getting the attached exception. During the migrati...
Hello,
I would like to ask about the PB Oracle DB driver
We have PB2017R2 (1756) & Oracle client 11.2 and DB Oracle 11.2
with migration to Oracle DB 19 I face issue where the Timestamps are handled as dates instead of Timestamps and because o...
Hola, estamos utilizando appeon 2019R2, necesito saber con que cliente Oracle esta certificado su funcionamiento....
HI,
Can anybody tell me if I can do the following.
Use Powerbuilder 2017 with Oracle 12c client to Oracle 19c database.
Regards
ML...
We have many PowerBuilder 2017 Release 2 applications that will need to be migrated to Release 3, as their attendant Oracle Server databases will be transitioning to 19c (12.2.0.3) in the future. Appeon PowerBuilder 2017 Release 3 is stated to suppor...
- Page :
- 1