Discussions tagged Oracle
We have a PowerBuilder 12.5 application that runs against Oracle 12 and Oracle 19c.
DBA's have noticed excessive queries against SYS.ALL_SYNONYMS. I understand that these queries have been a part of PowerBuilder for some time, and it seems they occ...
Version 2019 R2 Build 2353
We have a PowerBuilder application (32-bit) that connects to a .NET DLL via OLE. Within this DLL we connect to Oracle using Provider Factories. We recent decided to stop using “System.Data.OracleClient” and have begun usin...
Our DBA team tested Oracle’s Transparent Application Continuity (TAC) which allows a live switch of the database from one server to another without losing the Oracle connections to the database. When the test was performed against our PowerBuilder a...
When querying using query mode when connected to Oracle 19c, and the column being queried has an alias, the oracle statement looks like this.
(AND table.column aliase = 'Input data' )
Example:
In the select part:
COMPANY.STATUS COMPANY_STATUS
P...
Hello,We work with PowerBuilder 19 R3.We have just migrated our Oracle database to 19C.Since the migration, we have noticed the presence of .DMP files. These are taking up more and more space on our disks. We regularly delete them. Can you tell us wh...
I have multiple datawaindows that call Oracle stored procedures. Each one returns only ONE result set.
Within the stored procedure they may use temp tables and/or cursors to loop through the temp tables. Some are defined cursors (CURSOR c1_TempCur...
I have multiple datawindows that call Oracle stored procedures. Each procedure returns only ONE result set. I'm finding in datawindow they do NOT like datatypes of NUMBER or LONG. I've been changing them to Decimal(0) yet I can't really say that's...
Hi,
I have a table where one of the columns datatype is BFILE (the file is stored on a file server).
My question is how to use the field in PB?
Here is my test case
SELECT DOCUMENT_NAME, PNTR
INTO :FILENAME, :DOCUMENTFILE
...
Hi Experts,
My client wants to modernize our application (PowerBuilder 2022) and re-platform (Client considers PowerBuilder as Legacy old technology).
Seeking expert advice as to what is the next best tool available in the market which has withstoo...
Hello, On Windows 11 can't connect to the Oracle client
Here is the environment:
PowerBuilder runtime: 2019 R3 Build 2703
Oracle Client: Instantclient_19_18 and path is set correctly
Visual Studio Redistributable (64) 2015-2022
The error: OCI.DL...
Hi,I'm using PB2022, build 1900 with Oracle 19 database.
My question has to do with overloading and calling functions in a Oracle package. In native PB (Desktop) all works fine but with PowerServer there are issues.Here is my test case. The package ...
We have a datastore using an Oracle Stored Procedure Update. For the insert stored proc, one of the columns is mapped to an output argument, to capture the new transaction sequence ID generated by the stored procedure. Client Server app correctly pop...
We recently migrated a PB 2019 application to 2022 and also deployed it to PowerServer. It's been working very well. However, one user reported an issue recently. The user stated that the app was started and used without issue for a while. It was...
Hello everyone.
I need help, I have a powerbuilder 2022 and it is mounted on a server with windows server 2019, all my projects are set to run on power server and use an IIS server to publish it, so far everything works fine but, when my users star...
I've been attempting to utilize an Oracle Stored Procedure in a DataWindow to retrieve data, however upon retrieval I receive the following error.
ORA-06550 - Identifier '{indentifier}' must be declared.
The issue can be created in the DW painter.
...
Hi,
We have started looking into the possibilities on using PowerServer for our main PowerBuilder application.The first steps to build the powerserver application has been successful.
We are using the latest Powerbuilder 2022-version, connected to ...
Good afternon.
Please, how do I add an new option ORACLE 12 in my list "INSTALLED DATABASE INTERFACES"?
My powerbuilder is 2022 and I have oracle cliente 12.1. Today I use connected with option "O10 Oracle 10g", but we are going to migrate for orac...
hello friends, I have a project in powerbuilder that was originally in PB 12.5, this project was migrated to PB 2021, everything works fine but when generating a pdf from datawindow it generates a file with a weight of KB, I solved this by checking "...
Hi,
We are Evaluating PB2022 for Procuring Licenses.
Installed and migrated our application to 2022. (Train
Trying to make Power Server App.
Our Database is Oracle. (Down loaded the drivers when asked and installed)
We are facing the issue aft...
Using PB2022 Beta I was able to take our existing client/server app and create a working PowerServer project. However, after I uninstalled the Beta and installed PB2022 build 1878, the web version no longer works. Trying a Build/Deploy gives the er...
- Page :
- 1