Discussions tagged Stored Procedure
Procedure owner in datawindow stored procedure update
- How-to
- Last updated was 2 months ago
- Miguel Leeuwe replied 2 months 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 was 6 months ago
- Chris Pollach replied 6 months 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 was 6 months ago
- Anthony Mancuso replied 6 months 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 was 12 months ago
- Bryant Burnard replied 12 months 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: ...
Declare procedure calls different between 10.5 and 2017
- Issue
- Last updated was 2 years ago
- Chris Pollach replied 2 years ago
Hi,
I'm comparing 10.5 and 2017, trying to get the backing to move to 2017. I've come across an interesting issue that has me stumped.
Basically we have the following code
DECLARE OKButtonOnlyForm PROCEDURE FOR SYSADM.p_OKButtonOnlyF...
- Page :
- 1