Discussions tagged Oracle

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...
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...
  • Page :
  • 1