Discussions tagged Oracle

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...
I'm getting a parsing error in the C# model generator for a datawindow that I am not sure how to resolve -- see attached.  The datawindow works fine in PB when doing a preview and passing the required arguments.  The issue appears to related to a sub...
Hi Team,   We deployed our application to web recently and we are facing the following error when we try to run the application through web. We were able to connect to the database while configuring the profile. ---------------------------Error---...
Hello, I was wondering if anyone knows how to stop PowerBuilder from qualifying an Oracle procedure with its owner in DataWindow Stored Procedure Update properties. We are using a native Oracle driver, not ODBC. Best regards,Konstantin...
Hi all!I got that on Appeon web when trying to retrieve.I guess it is a problem with decimal configuration, but I cant find an answer.Can anybody help me?Im using Appeon 2019 with Oracle 11g and my decimal separator is ","This is the result running o...
I'm late to this topic so I must assume it has been asked and answered many times but I need to ask: I'm embarking on building an app to run on a tablet (iPad). My question is: How does this app connect to an Oracle database residing on a server in ...
Hi All; I will be setting up an Appeon Multi tenant application where our application with be a Saas. We are using PB 2017 R3 Build 1858 (and AEM of same version), Oracle 12g to provide this service. Is there a guild line on how to allow multi db c...
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...
  • Page :
  • 1