I have a stored procedure in SQL Server: CREATE PROCEDURE [GROUP1].[test_return]( @OUTVALUE integer OUT ) AS begin      SET @OUTVALUE = 999999;     RETURN end In Powerbuilder, I've set up a DECLARE and EXECUTE statement: long ll_result DECLARE te...

Hello!I have the problem that I have to call the MS SQL Server stored procedure sp_set_session_context to set a context variable. Unfortunately this does not work with the PowerServer. The PowerServer always gives me the message 'PowerServer.Api.Se...

I have multiple datawindows that call Oracle stored procedures.  Each procedure returns only ONE result set.  I'm finding in datawindow they do NOT like datatypes of NUMBER or LONG.  I've been changing them to Decimal(0) yet I can't really say that's...

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...

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...

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 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...

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...