Discussions tagged Oracle
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...
Oracle 18c
- Resolved
- How-to
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...
PowerServer Oracle decimal separator
- Resolved
- How-to
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 ...
Oracle 2 PostgreSQL
- Resolved
- Issue
Good morning.
Im 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 compat...
Hello All,
Does PowerServer Support ORACLE instant client or i must install the full client.
im trying with the instant client and get the following error
Testing Data Source ora failed: System.Data.OracleClient requiere la version 8.1.7 o po...
Failed to connect to database.
- Resolved
- Issue
Im 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 firewa...
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 recover the c...
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
...
Connection Error 999 on Windows 10
- Resolved
- Issue
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. ...
Find Questions by Tag
.EXE
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Authentication
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Bui
Button
C#
C# Class Importer
C# Editor
Calendar
Camera
Certificate
Chrome
Citrix
Class
Client
Client/Server
Cloud
Cluster
Collection
COM
Command Line
Compiler
Compression
Computed Field
Configuration
Controls
Cookies
Cordova
Crash
Cross-Platform
Crosstab
CSharpAssembly
CSharpObject
CSS
CSV
Cursor
Data
Database
Database Driver
Database Painter
Database Profile
Database Provider
DataObject
DataSource
DataStore
DataStore (C#)
DataStore (PS)
DataType
DataWindow
DATE
DATETIME
DB2
Debug
Debugger
Debugging
Deployment
Design
DLL
DO-WHILE
Dockable
Documentation
DOUBLE
Download
DragDrop
Edge
Edit Style
Editor
Elevate Conference
Email
Embedded SQL
Emulator
Encoding
Encryption
Enhancement Request
Entity
Entity Framework
ERP
Error
Event
Event Handler
Event Handling
Excel
Exception
Export
Expression
External Functions
F#
Field
File
File Access
Filter
Firefox
Firewall
Font
FOR-NEXT
Foreground
Format
Function
Garbage Collection
Generate Data Models
GeoLocation
Git
Graph
HANA
Hash
Header
HTML/5
HTTP/S
HTTPClient
Icon
IDE
Identity
IIS
IMAPI
Import
InfoMaker
Inheritance
Installation
Integer
IntelliSense
Interface
Internet
Internet Explorer
iOS
IPA
iPad
iPhone
IWA
J#
Java
JavaScript
JBoss
JDBC
JOIN
JSON
JSONGenerator
JSONParser
Kestrel
Label
Lambda
Large File
LDAP
Library
License
LINQ
Linux OS
Load Balancing
Localization
Localized PBVM
Log In
Log Out
Logging
LONG
LONGLONG
macOS
MAPI
Maps
MDI
Memory
Memory Leak
Menu
Merge
MessageBox
Messagging
Method
Migration
MIME TYPE
Mobile
Model
ModelMapper
ModelStore
ModelStore (C#)
MSOLEDBSQL
Multi Threading
MVC
MySQL
n-Tier
Namespace
NativePDF
NVO
OAuth
ODATA
ODBC
Office
Offline
OLE
OLEDB
Online
Open Source
OpenAPI
OpenSSL
Oracle
OrcaScript
Other
Outlook
Output
Package
Parameter
Patch
PayPal
PB Classic
PB Native
PB.NET
PBC
PBD
PBDOM
PBG
PBJVM
PBL
PBNI
PBORCA
PBVM
PBX
PDF
Performance
Permission
PFC
Picture
Pipeline
Play Store (Google)
Plugin
Popup
Port
POST
PostgreSQL
PowerBuilder
PowerBuilder (Appeon)
PowerBuilder (SAP)
PowerBuilder Compiler
PowerScript (PS)
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Roadmap
RPC
Runtime Packager
SaaS
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
TIME
Timer
TLS/SSL
Tomcat
TortoiseGit
TortoiseSVN
Transaction
Transparency
Trial
Trigger
TRY-CATCH
TX Control
Type
UI
ULONG
UltraLite
Uninstall
Unit Test
Unit Testing
UNIX OS
Update
Upgrade
Upload
URL
User Center
User Object
UWP
Validation
VARCHAR
Variable
Versioning
Visual Studio
Visual Studio Code
VM
Voice
Warning
WCF
Web Extensions
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom