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

Resolved oracle materialized view & Powerbuilder

  1. Issue
0
Votes
Undo
  1. Gimmy Susan
    Gimmy Susan
  2. PowerBuilder
  3. Monday, 5 March 2018 16:16 PM UTC 
Hello.
I created in Oracle DB one 'materialized view'

When developing the datawindows and selecting those View PB2017R2 responds to me:
ORA-00936 Missing expression.

I tried to browse from the db painter too.
The system can not recover the columns of the materialized view

is it right ?

 

GMY

  1. Oracle
Powerbuilder PULL ( git )
PowerBuilder 2019 and SVN source control
Accepted Answer
Gimmy Susan
Gimmy Susan Accepted Answer Pending Moderation
  1. Friday, 17 April 2020 14:50 PM UTC
  2. PowerBuilder
  3. # Permalink

resolved

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 17 April 2020 15:42 PM UTC
What was the solution?
  1. Helpful
Gimmy Susan
  1. Gimmy Susan
  2. Friday, 17 April 2020 16:45 PM UTC
wrong pemission in oracle
  1. Helpful
There are no comments made yet.
Responses (5)
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Tuesday, 6 March 2018 14:32 PM UTC
  2. PowerBuilder
  3. # 1

Hi,

I have create a simple materialized view on Oracle 11 to test it and had no problems with PB 2017 (R1).

 

Comment
There are no comments made yet.
Gimmy Susan
Gimmy Susan Accepted Answer Pending Moderation
  1. Tuesday, 6 March 2018 10:16 AM UTC
  2. PowerBuilder
  3. # 2

Hi

@Chris:

Thanks, but i'm on oracle version 10.2.04.

 

@Govinda. 

Thanks for answer, but the problem is on painter not on sql in script.

 

@All

I am using the same user both in the creation of the tables and in the development of PB2017R2
Does anyone use the materialized view?
Is PB certified for use in the Oracle environment?

 

thanks all

Comment
Michael Kramer
  1. Michael Kramer
  2. Tuesday, 6 March 2018 12:30 PM UTC
Hi Gimmy,  No Oracle DB on hand so this is from memory:



PB IDE uses certain calls to system views to retrieve lists of tables, columns, views, you name it. Unfortunately I don't remember those calls.



Looking at the call to retrieve list of tables/views should indicate where the problem lies. It may be access rights.



HTH /Michael

  1. Helpful
There are no comments made yet.
Govinda Lopez @Appeon
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Monday, 5 March 2018 17:45 PM UTC
  2. PowerBuilder
  3. # 3

Hi Gimmy,

 

Have you tried adding the [dbo] prefix? Ie., SELECT col1 FROM dbo.tbl WHERE col1 = 1;

 

 

Regards,

Comment
Gimmy Susan
  1. Gimmy Susan
  2. Tuesday, 6 March 2018 10:07 AM UTC
.

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 5 March 2018 16:59 PM UTC
  2. PowerBuilder
  3. # 4

Hi Gimmy;

   I do not have Oracle installed - but, was able to create Materialized Views in ASE, SS & SA and then consume these in a DW object within PB 2017 R2, as follows:

DB Painter test ...

 

DW Painter test using  Materialized View  from above...

 

My suggestion would be to contact your Oracle DBA for more information. Maybe its a "right's" issue?

HTH

Regards ... Chris

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