Discussions tagged Oracle

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...
Does PowerBuilder 19 supports or complaint with Oracle 12.2c?...
This is almost a verbatim repeat of a question asked a year ago for which I didn't see a conclusive answer. I finished testing two migrations with Oracle 9 and am now ready to test the applications with Oracle 18c. My understanding is that PB19 supp...
Hi. The Appeon Newsletter 2020 in January made the following comment: Oracle Compatibility Alert for PowerBuilder UsersExisting versions of PowerBuilder are not compatible with Oracle 18c or 19c. If you are using PowerBuilder 2019, please apply MR #...
  • Page :
  • 1