Discussions tagged Oracle

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...
Trying to connect to an Oracle database that worked on Monday and now does not. The DB is up and running and I can access it as a client server PB APP.  When I check the profile used to deploy to Power Server I get the Failed to connect message.  I c...
Hi All, I am new to Power Builder .NET 12.6 . How do i make connection to Oracle database? , i have software installed on my machine which is Windows 10 64-bit.  Thanks in advance. NA   ...
Windows 10, 64 bit Oracle 12 PB v12.1 Running the EXE and PBDs Used Inno Setup to create an installer. Ran the installer on the Win 10 VM - Everything appears to have installed correctly and in the correct locations. Oracle 12 is installed.   ...
I work con DB Oracle 11g 32 bits, but I can't deploy apps en mobile or web.  ...
  • Page :
  • 1