Discussions tagged Stored Procedure
We have a datastore using an Oracle Stored Procedure Update. For the insert stored proc, one of the columns is mapped to an output argument, to capture the new transaction sequence ID generated by the stored procedure. Client Server app correctly pop...
Oracle Stored Procedure Retrieving Data
- How-to
- Last updated 2 months ago
- Miguel Leeuwe replied 2 months ago
I've been attempting to utilize an Oracle Stored Procedure in a DataWindow to retrieve data, however upon retrieval I receive the following error.
ORA-06550 - Identifier '{indentifier}' must be declared.
The issue can be created in the DW painter.
...
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...
PowerServer 2021 - Issues with Oracle StoredProcedure
- Issue
- Last updated 9 months ago
- David Xiong @Appeon replied 9 months ago
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...
Is there a maximum size for output ParamValue arguments from a stored procedure in SnapObjects
- Resolved
- Issue
- Last updated 10 months ago
- Daryl Foster replied 10 months ago
Hi, we've been using SnapObjects for quite a while without too many issues, but today we found that one of our stored procedure calls truncates the output parameter to 4000 characters. Is that configurable in SnapObjects, or is it a hard limit? We a...
Hi team,
We have migrated our code from PB11.5 to PB2019. During our initial testing we found our application is getting crashed.
After looking more into it, we found Stored procedure Execute command from PB is making the application to crash.
We ...
PB 2019 Execute MYSQL Stored Procedure
- How-to
- Last updated 2 years ago
- John Fauss replied 2 years ago
can you give me instructions and examples on how Execute MYSQL Stored Procedures on PowerBuilder 2019?
thanks...
Getting Error Details from SelectProcedure?
- Resolved
- Advice
- Last updated 2 years ago
- Daryl Foster replied 2 years ago
Hi, I'm using the SnapObjects SelectProcedure function in a web api and I want to know how to catch an error that occurs in the stored procedure (from a RAISERROR command in the stored procedure.) The SelectProcedure works ok and fills my model with...
Execution of stored procedure from Powerbuilder app stops inexplicably
- Issue
- Last updated 2 years ago
- Tom McManus replied 2 years ago
Our Powerbuilder application executes a stored procedure in Sybase and has been running without problems for a few years. About a month ago the stored procedure began stopping without finishing and did not report any error to the calling application...
PB 2017 R2 Crashed on Second Execution of Stored Procedure
- Resolved
- Issue
- Last updated 2 years ago
- Glenn Barber replied 2 years ago
Our application is PB 2017 R2 with SQL Anywhere 16. The application is build in PFC
We have created a stored procedure which creates a snapshot of all our tables (16) involved in a complex transaction. We want to fire this after an update is succe...
ExecuteProcedure method in SnapDevelop 2.0
- Resolved
- Issue
- Last updated 2 years ago
- Logan Liu @Appeon replied 2 years ago
We have migrated our web api to SnapDevelop 2.0. It runs on a Windows 10 machine using an Oracle 11g database. The api method below worked fine in SnapDevelop 1.0 but now after the migration we are getting the attached exception. During the migrati...
DW Data Source as Stored Procedure - Wizard does not show all procedures
- Resolved
- How-to
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
Hi all,
we try to get data into a DataWindow over stored procedures. Further, we also want to be able to save the data via stored proc. The dialog for the first generation of the DataWindows Objects, where the procedures can be selected, does not sh...
RPC error "Can not get parameters of procedure"
- Resolved
- Issue
- Last updated 2 years ago
- Ken Guo @Appeon replied 2 years ago
As a workaround for the problem with embedded SQL calling a stored procedure with an OUTPUT parameter (which I reported earlier this week), I used a remote procedure call. I am using PB19 on W10, SQLNCLI11 and SQL Server 2016.
The remote procedure c...
PB 2019 Execute SQL Server Stored Procedure with OUTPUT parameter
- Resolved
- Issue
- Last updated 2 years ago
- Linda Kelty (Dudzic) replied 2 years ago
I'm in the process of migrating our PB 12.5.2 applications to PB19. I'm using the SQLNCLI11 provider. Have just run into the following error upon executing a stored procedure.
SQLDBCode 179SQLErrText:SQLSTATE = 42000Microsoft SQL Server Native Clien...
PB 2017 R3, ODBC ASE, Stored Procedure Declare, C0038 on Variable
- Advice
- Last updated 3 years ago
- Charlie Cummins replied 3 years ago
Hello,
Running PB 2017 R3, using ODBC to connect to ASE database.
PB in-code stored procedures declares are failing on recompile the with following error (ran fine under ASE Native). C0038: SQLSTATE = ZZZZZ[SAP][ASE ODBC Driver][Adaptive Server En...
Procedure owner in datawindow stored procedure update
- How-to
- Last updated 3 years ago
- Miguel Leeuwe replied 3 years ago
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...
Performance of using Stored Procedure in datawindow
- Advice
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
Hello,
Using Pb 11.5, Sql Server 2012 express
Got a datawindow retrieving data through a stored procedure from the database. Suddenly it's taking more time to retrieve.
when the same query is executed in the SSMS, it takes only a couple of seco...
How to Source a Stored procedure with Date input parms in a create of a datawindow.
- Resolved
- How-to
- Last updated 3 years ago
- Anthony Mancuso replied 3 years ago
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...
Error when calling an Oracle SP from PowerServer Code
- Resolved
- How-to
- Last updated 4 years ago
- Bryant Burnard replied 4 years ago
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...
After migrating from PB12.5 to Appeon PB 2017 (1681), our application crashes with this message in the Windows Event Viewer - application:
Faulting application name: PB170.EXE, version: 17.0.0.1681, time stamp: 0x59c46b21
Faulting module name: ...
- Page :
- 1