• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • DW Data Source as Stored Procedure - Wizard does not show all procedures

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved DW Data Source as Stored Procedure - Wizard does not show all procedures

  1. How-to
0
Votes
Undo
  1. Gzim Ramizi
    Gzim Ramizi
  2. PowerBuilder
  3. Friday, 8 May 2020 11:01 AM UTC

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 show all packages/procedures. The dialog where you can select the procedures for the update/insert/delete shows a larger list. We looked at the grants in the database. We changed the DBProfile settings, but that helps only partially.

Are there other settings that can be made to influence this list? Or are there other aspects we should consider?

We are on: PowerBuilder 2017 R3, Oracle 12g.

 

TIA.

  1. DataSource
  2. DataWindow
  3. Stored Procedure
DotNetAssembly and DotNetObject runtime files
No prompt to add C# project to PowerBuilder worksp...
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 8 May 2020 18:24 PM UTC
  2. PowerBuilder
  3. # 1

Hi Gzim;

  Normally, the SP/SF's that you can see is tied to the DB privileges that your DBMS Login ID has been granted by your DBA. I would check with the DBA team and see what they say.  HTH

Regards ... Chris

Comment
Gzim Ramizi
  1. Gzim Ramizi
  2. Monday, 11 May 2020 18:00 PM UTC
TY Chris. In addition to the privileges, it was necessary that the procedure also required a record type (in out) as the last parameter.



BTW: It is so sad that the old News Group posts from PowerBuilder / DataWindow can no longer be found. I'm sure something like that has been answered there several times...
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.