Discussions tagged Stored Procedure
Windows 10 PB Version 6.5.1 Postgres 12psql-ODBC 12.02.01 Connection
Hi,
Error in PB calling stored procedure, The error message is Procedure has already been executed.
I have implemented a minimal use case, see the attachment.
I created the fo...
We're attempting to migrate our large 20+ year old application to PowerServer 2022 R2. We have an ORACLE database, and have a number of RPCs as well as a few datawindows using stored procedure updates. Some of the remote procedures have PRAGMA autono...
I have a user who is trying to reference a stored procedure from InfoMaker.
Here are the steps she's taking.
Create a New Tabluar Object.
In Tabular Report Generator, click Stored Procedure, and then click Next.
Choose the s...
Hi,
In Powerbuilder 2022, I have a report fetching data from a MS SQL stored procedure returning two result sets. This works fine when connected to a SAP ASE database, but after migrating to MS SQL, it looks like only the first result set from the p...
Hi
I'm converting a Powerbuilder project to Powerserver. Some of the windows use SQLPreview to call stored procedures to update the database.
SQLPreview isn't supported by Powerserver, so I want to modify the datawindow dynamically to use the stor...
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...
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...
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...
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 ...
can you give me instructions and examples on how Execute MYSQL Stored Procedures on PowerBuilder 2019?
thanks...
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...
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...
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...
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...
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...
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...
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...
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...
- Page :
- 1