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

Resolved Procedure owner in datawindow stored procedure update

  1. How-to
1
Votes
Undo
  1. Konstantin Goldobin
    Konstantin Goldobin
  2. PowerBuilder
  3. Tuesday, 17 September 2019 13:07 PM UTC

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

  1. DataWindow
  2. Oracle
  3. PowerBuilder
  4. Stored Procedure
  5. Update
Take photos and save into Database
Putting a ListBox in the Toolbar
Responses (5)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 18 September 2019 21:14 PM UTC
  2. PowerBuilder
  3. # 1

I posted it as a request (bug 3362) and sofar this it what Chris has answered me. I'll try to do that tomorrow, though maybe not for everyone it's easy to get dbo rights on his assigned Oracle user.

 

Hi Miquel;

  I believe that the DBO (DB Owner) is added to the DWO's SQL statement when the PB Developer's DBMS login ID is not assigned the DBO role. I have seen this in ASE and SQL Server. By adding the DBO role in those DBMS for me, has always then allowed the PB IDE to drop the prefix.

  Have you tried this in Oracle?

Regards ... Chris


Comment
Konstantin Goldobin
  1. Konstantin Goldobin
  2. Thursday, 19 September 2019 07:37 AM UTC
Thanks, Miguel! I believe DBO is a Sybase/SQL Server artefact but I wouldn't know its counterpart in Oracle... Do you?
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 19 September 2019 09:01 AM UTC
I've tried to assign SYS and SYSDBA to my user and then specify SYSDBA for "Connect as".

It doesn't make a difference.

I've also noted that once you've created the dw, there's no way to "change the datasource". The icon and the menu option is disabled.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 18 September 2019 20:41 PM UTC
  2. PowerBuilder
  3. # 2

I guess the best thing to do here, is to ask for an improvement / feature request / enhancement to Appeon to achieve the goal of NOT having to edit the dw source code manually all the time.

I'll do that right now.

 

Comment
There are no comments made yet.
Juan Alejandro Lam López
Juan Alejandro Lam López Accepted Answer Pending Moderation
  1. Wednesday, 18 September 2019 19:32 PM UTC
  2. PowerBuilder
  3. # 3

Respect to PB does not list synonyms for procedures/packages in the selection list..., please verify the file adjunct.

Attachments (1)
Synonyms.pdf
Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 18 September 2019 19:56 PM UTC
(sorry should have sent that in English)
  1. Helpful
Juan Alejandro Lam López
  1. Juan Alejandro Lam López
  2. Wednesday, 18 September 2019 19:59 PM UTC
Lo que quiero decir es que si se listan los sinonimos, las imagenes que ves son para que compruebes como se hace.
  1. Helpful
Konstantin Goldobin
  1. Konstantin Goldobin
  2. Thursday, 19 September 2019 07:49 AM UTC
Hi Juan! Not sure I see your point. If I understand correctly your example, you have a synonym for sys.utl_listar in the LAM schema, and when you select one of its procedures PB qualifies it with the synonym owner LAM, which is exactly what I want to avoid...
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2019 21:31 PM UTC
  2. PowerBuilder
  3. # 4

In the PB IDE, in the connection profile, do you have the powerbuilder catalog owner set to the schema who owns the stored procedure? Do you have synonyms?

Sorry cannot test now myself, as our servers are being maintained.

If not ... do what Juan Alejandro says, though that's something you might have to repeat every time you change something on the dw.

Comment
Konstantin Goldobin
  1. Konstantin Goldobin
  2. Wednesday, 18 September 2019 11:33 AM UTC
Yes to both questions - and that's why I don't understand why PB insists on qualifying procedure calls with their owner. BTW, surprisingly enough, PB does not list synonyms for procedures/packages in the selection list...
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 18 September 2019 13:06 PM UTC
Yes, I've tested it on our system too. I think this goes back to the days when Oracle was a big competitor of Sybase System 10, ASE, etc. In the early years Powersoft and Sybase were "most compatible" (in favour) and fully supported Sybase, but not so much the competitors. This has been like this since the nineties if I remember well.
  1. Helpful
There are no comments made yet.
Juan Alejandro Lam López
Juan Alejandro Lam López Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2019 20:03 PM UTC
  2. PowerBuilder
  3. # 5

The method that I use, is to edit the Datawindow, by right clicking on the datawindow and selecting the Edit Source option. Then remove the Owner from the Invocation of the Stored Procedure.

Comment
Konstantin Goldobin
  1. Konstantin Goldobin
  2. Wednesday, 18 September 2019 11:30 AM UTC
Thanks! This is what we've been doing as well but this is ridiculous, don't you think?
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.