Discussions tagged Oracle
PB2019 R3 "OCI.DLL could not be loaded"
- How-to
- Last updated 3 weeks ago
- Ken Guo @Appeon replied 3 weeks 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 2 months ago
- Chris Pollach @Appeon replied 2 months 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 5 months ago
- Chris Pollach @Appeon replied 4 months 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 5 months ago
- René Ullrich replied 4 months ago
Is there a way to keep PB from selecting from ALL_SYNONYMS in Oracle?
May be generated by call to SyntaxFromSQL...
SnapObjects Oracle Model Binding
- Issue
- Last updated 6 months ago
- Logan Liu @Appeon replied 6 months ago
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 6 months ago
- Narayanamoorthy Thangavel replied 6 months 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...
OCI.DLL not loading for Powerbuilder 2017 R2 and Oracle Client 19
- Resolved
- Issue
- Last updated 9 months ago
- Dennis C. Clark replied 9 months ago
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...
ExecuteProcedure method in SnapDevelop 2.0
- Resolved
- Issue
- Last updated 9 months ago
- Logan Liu @Appeon replied 9 months ago
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...
PB2017 Oracle 19 timestamps handled as date
- Issue
- Last updated 9 months ago
- Antonin Krejci replied 9 months ago
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...
Cliente oracle recomendado para appeon 2019R2
- How-to
- Last updated 10 months ago
- Chris Pollach @Appeon replied 10 months ago
Hola, estamos utilizando appeon 2019R2, necesito saber con que cliente Oracle esta certificado su funcionamiento....
Powerbuilder 2017 with Oracle 12c client to Oracle 19c database
- Resolved
- How-to
- Last updated 11 months ago
- Miguel Leeuwe replied 11 months ago
HI,
Can anybody tell me if I can do the following.
Use Powerbuilder 2017 with Oracle 12c client to Oracle 19c database.
Regards
ML...
RE: transitioning From 2017 Release 2 to release 3
- Misc
- Last updated 1 year ago
- Bill Asby replied 1 year ago
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 Oracle 12.2c
- How-to
- Last updated 1 year ago
- Michael Kramer replied 1 year ago
Does PowerBuilder 19 supports or complaint with Oracle 12.2c?...
PB19 connection to 18c - TNS:no listener
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
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...
Powerbuilder with Oracle 18c using ODBC
- Resolved
- Advice
- Last updated 1 year ago
- Larry Peters replied 1 year ago
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 #...
PowerBuilder 2019 Oracle 18C connectivity support.
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hello,
I am using Appeon PowerBuilder 20019. I was wondering if you are planning on providing support that allows Oracle to access Oracle Database server version 18C ?
Please let us know.
Thanks.
Cheers,
Manny Strachan
PowerBuilder 2019 Develop...
Retrieving LONG column in .NET datastore (Oracle)
- Resolved
- Issue
- Last updated 1 year ago
- Thomas Rolseth replied 1 year ago
We are using PB/SnapDevelop 2019 build 2082 with an Oracle 12 database. I created a datawindow/datastore object with a SELECT that matches the columns and datatypes of an external datawindow and then ported it to the API using the C# Model Generator...
Hello,
I have a simple Oracle stored function as follows:
CREATE OR REPLACE FUNCTION test_double(a_in NUMBER) RETURN NUMBER ISBEGIN RETURN a_in;END test_double;
And a simple test window with a multilineedit and command button whose clicked event s...
Hi,
We deployed to web recently. We have been facing the following issue frequently.
---------------------------BFMS---------------------------Errors occurred in the Appeon communication layer.Possible causes: 1. The network is unstable or di...
Hi,
We have deployed our application through web. Every time we try to log in to the application through web we need to kill the checked sessions that were open previously in the AEM. And then it works fine for some number of sessions for the same d...
- Page :
- 1