Discussions tagged Oracle

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 ...
Good morning. I'm trying to convert an application from oracle db to the PostgreSQL db. In the DW SQL we have some proprietary syntax that does not work in the destination db. Is there a utility that checks DW sintax to understand its c...
Hello All, Does PowerServer Support ORACLE instant client or i must install the full client. i'm trying with the instant client and get the following error  Testing Data Source ora failed: System.Data.OracleClient requiere la version 8.1.7...
I'm getting failed to connect to database when using Oracle Native Drivers only when using the configuration tools to deploy to my Appeon Power Servers.  This happened after a corporate McAfee Client update with everything locked down using the f...
Hello. I created in Oracle DB one 'materialized view' When developing the datawindows and selecting those View PB2017R2 responds to me: ORA-00936 Missing expression. I tried to browse from the db painter too. The system can not rec...
  • Page :
  • 1