Discussions tagged Oracle
Hi,
I am getting a powerserver error when I am updating a datawindow with a package stored procedure in Oracle 19.
My Powerbuilder version is: Appeon Powerbuilder 2021 CloudPro Edition.
Database is Oracle19 64 bit.
When I am updating a datawindow...
Client and Server Communication
- Resolved
- Advice
Hi,
I need suggestion for below case.
We are doing application server migration from HP-UX to RHEL. Our application client we used for PowerBuilder 2017 and Server side logic we written in Oracle Tuxedo. So ,now data the communication between clien...
After upgrading Oracle Database to version 19c - we have an issue, a runtime failure when a stored procedure with an input parameter of a table type or an array is being called from the PBL.
Power Builder: Version 2019 R2 Build 2353
Oracle Database...
Hi all. Apologies for resurrecting this question, I thought I had discovered the answer but no luck.
We have an odd error occurring in an app built in Powerbuilder after an Oracle 19c upgrade. I am wondering if anyone else has seen this. Anytime the...
Hello everybody,I'm testing my PB Client / Server application (PB2021) compiled with PowerServer2021. The data server is Oracle 12c.
The application makes use of calls to Oracle StoredProcedure (PL/SQL) and in the PowerServer version I have some pro...
We have a PB classic application migrating to PS (latest PB etc.), connecting to Oracle 19 database. When the application runs in PS it is not encapsulating multiple SQL statements in a transaction, almost as though a commit is issued between each s...
Challenge we have
The DB Connections are pooled by IIS, Oracle 19c as BACKEND and we would not able to capture the OS USER ID for Auditing the actions.
Audit of user actions are captured using bcakend triggers and user name is used as "OS USER", si...
PB 2019 R3 build 2703
Old Database Oracle 10g
New Database Oracle 19c
We have to change our database application to the new Database Oracle 19 c (before it was Oracle 10g).
Does we have to change to the new Oracle interface (PBORA.dll) as it m...
datetime variable doesn't working with RPC
- Resolved
- Issue
Hi All,
I am using PowerBuilder 2019R2 build 2353 and Oracle 19C. Recently we upgrade our database from Oracle 12 to 19.
I have procedure which OUT parameter is date table type. before database migration its return proper value in PB's dateti...
SnapDevelop 2021: C# Model Converter issue
- Resolved
- Issue
We have a client that made a simple change to a datawindow. They changed a column in the select from CAST(col1 AS CHAR(10)) to TO_CHAR(col1). They then used the C# Conversion tool in SnapDevelop 2021 to import this change into the API which was succe...
When trying to run a PowerServer application using PB 2021 Build 1288, I am getting the following error when trying to connect to the Oracle database:
PB application execution Error (R0222)
Error: Session not created. Please create a session using...
Hi,
I am getting database connection timeouts on a PowerServer 2020 web application even when in use (not idle). Seems to be after several minutes. The app will automatically reconnect to the Oracle 12c database but the fallout is that the sessio...
Hi,
an error occurred while attempting to call PL/SQL Oracle procedure with string array as parameter using Oracle 19 server.
Tried to install Oracle 19 client and set PBNewSPInvocation='Yes' in the DBPARM connection parameter with no result.
I sa...
Hello,
I'm trying to create a database connection in SnapDevelop 2019 R3 (I tried in R2 also) to an Oracle database, but I get the error "ORA-12537: Network Session: End of file". It's strange because I can connect to this database in Powerbuilder w...
Hey folks,
I just installed PB2019 R3, Build 2670. Migrated an app from PB2017 R2. The only reason for the 2019 upgrade is because we're moving to Oracle v19 databases. Wanted to get the app migrated before the DB upgrade.
I've searched high a...
Error Connecting Oracle 19C DB
- Resolved
- How-to
I am trying to connect the Oracle 19C DB from PB 2019 R3(Both Source and DB Painter) and also via Application exe, And I am getting the below error. Do I need to change any settings from PB side.
SQLCA.DBMS = "ORA Oracle" - connecting using this ...
Hi.I am converting our application from PB2017 R3 to PB2019 R3. All runs fine.Except I have a problem concerning the new runtime environement and loading Oracle oci.dll with our application.My application is named "buisy" and I would like to provide ...
Hello,
since I migrated an old app developped with PB 7 to PB 2019, I have a big problem with some SQL queries from my Datawindows when executed on a database under Oracle 11g. I get this message : 1722 - select Error : SQLstate = 22005.
But the s...
Hello,I have column "period", i set an editmask like ### to prevent enter a non-digits characters.When I clear this column (i expected null value in table) - there is always zero.What I want to achieve: column with numbers only and null - when null t...
Is there a way to keep PB from selecting from ALL_SYNONYMS in Oracle?
May be generated by call to SyntaxFromSQL...
Find Questions by Tag
.EXE
.NET 6.0
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET DataStore
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
AI
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Asynchronous Methods
Authentication
AutoBuild
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Build
Button
C#
C# Class Importer
C# Editor
C# Model generator
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
Docker
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
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
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
PowerBuilder Runtime
PowerClient
PowerScript (PS)
PowerScript IDE
PowerScript Migrator
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
PowerServerLabel
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Rich Text
Roadmap
RPC
Runtime Packager
SaaS
Scaffolding
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SMTPClient
SnapDevelop
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
SqlModelMapper
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
TabbedBar
TabbedView
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
Theme
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 API
Web Extensions
Web Service
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom