Discussions tagged Oracle
Hi,
Trying to deploy a simple app as a test to PowerServer Web on a remote server via the Toolkit. The "Database Type Profile Configuration" screen "Test Connection" Fails with the simple message "Failed to connect to the database" using either ODB...
How do I update a blob in an Oracle table column dynamically?
I know about UPDATEBLOB in PowerBuilder imbedded statements, like
UPDATEBLOB “tablename” set “blob_column_name” = :lblob;
This script uses SQLSA because the column name is known only...
We are using PB2017R2, running against an Oracle database. We have a local external procedure call that uses array parameters, both in and out. We began testing Oracle 18c recently, and post-upgrade we found that this procedure started failing with a...
I'm experiencing a problem in connection with string-double conversion in PowerBuilder:
If HKCU/Control Panel/International/LocaleName registry entry is set to a language code with a sub-form of the language (e.g. en-US), and the HKCU/Control Panel/...
I'm experiencing an issue with Describe function in Powerbuilder 2017 R3. If I call Evaluate within the Describe function, then it gives me a wrong result, when I change the HKCU/Control Panel/International/sDecimal entry in the registry from a dot (...
I am trying to create a new data window by sourcing an Oracle Stored procedure. The stored procedure has compiled and been tested using Oracle SQL Developer. It runs fine. However when i try to create a data window it throws a Date Error before i can...
Hi;
I'm using PF2017 R3 Build 1858, deploying to PowerServer via IIS, using Oracle instant client 18.3 64 bit, running in Chrome 74.0.3729.131 64 bit. The transaction object uses a dynamic connection to log on.
When a client logs in we test to see ...
Hello Appeon Powerbuilder team,
We have a Power builder application which migrated from power builder 9.0 to power builder 2017R3. The database used was Oracle 11g. the 11G client has no issues connecting with PB2017R3. The problem lies with the ...
Dear Appeon Team and PB Experts,
We know there is a workaround for Appeon PB2019 to support Oracle 18c by installing Oracle 12c Client, Thanks to Chris Pollach and Olan Knight for your replies :)
Do you know when Appeon Powerbuilder will fully supp...
Hi All,
I installed Powerbuilder 2017 and have oracle 11g client 32 bit installed in windows server 2008 machine 64 bit.
When trying to connect to database through DB profile , I am getting error "ORA-12154: TNS:could not resolve the connect ide...
I am running PowerBuilder 2017 R3, I have a data window that executes an Oracle procedure with an output parameter as a cursor.
If I execute the datawindow from within the powerbuilder IDE the results are returned and I can see the correct data.
Wh...
Dear Appeon team and PB experts,
We plan to start testing PB2019 Beta with Oracle 18c, do you know if there are known issues that we should be aware of?Best Regards,
Jing Huang...
Hello everyone,
I am running into a General Application crash when running a 64Bit build.
I am trying the Native Oracle driver against an Oracle client 18. I can run the application through the debugger without issue, it's just the exe crashes wh...
Hi;
Using Windows 10, PB 2017 R3 Build 1858 (trial for a Proof of Concept), Oracle 11G and the Oracle Instant Client 18.3 64 bit
For the PowerServer side, using a Native Interface Oracle 10g/11g/12c transaction.
I'm using oracle stored procedur...
Infomaker PSR report is requiring double quotes around all table names and field names.
Interactive SQL window does not require it.
only when creating a PSR report.
EX.
select "component"."cmpnt_id", "component"."cmpnt_name" from "component" wher...
Hello,
I have a problem between PowerServer Web and Oracle. The decimal values are multiplied by 100. I suspect a decimal separator problem.
How can i define it ?
It works well in PowerBuilder.
Thank you
Olivier...
Hello,
We are missing several metadata types after the database change from Oracle 10 to Oracle 11. how can we add these? (Example: Timestamp)
tia...
We have a Oracle 12c Database. In a table in the database is a column with a RAW data type. The column is designed to not allow nulls per requirements of the DBA.
We are trying to retrieve/insert/update this column. A regular datawindow does not...
Anyone using oracle 18c yet?
Any know of specific support planned for Oracle 18c? I know the current drivers should (will) work fine, but since you announce specific support for SQL Server 2017, will there also be specific support for oracle 18c ...
Using Oracle 12 with Appeon PB trying to be anal about runtime connection parms (mostly run thru Citrix). Do you have any comments on existing settings below or recommendations to consider adding as a general "best" default? Note for Sybase I used ...
- Page :
- 1