| Using a view to populate data block - [message #143654] |
Fri, 21 October 2005 06:34  |
sikorsky05
Messages: 40
Registered: October 2005
|
Member |
|
|
I created a complex view (See Below)
CREATE OR REPLACE FORCE VIEW GENCARAM.DMC_INPUT_VIEW AS
Select a.mmc,a.GROUP_CODE,a.MODEL,a.archive_number,b.nomenclature
from gencaram_dmc_dtosc a, gencaram_prediction_data b
where a.mmc = b.mmc
and a.group_code = b.group_code
and a.model = b.model
and a.unit_price is null
and b.roll_id = 0
order by a.mmc;
CREATE PUBLIC SYNONYM GENCARAM_DMC_INPUT_VIEW FOR GENCARAM.DMC_INPUT_VIEW;
Table has been granted select to role gencaram_user. User sika28 has was granted to the role (gencaram_user).
In forms I create a datablock to display a.mmc and b.nomenclature
When I run the forms, data will only query if I have Select access directly on those 2 tables... IF I typed
Select * from gencaram_dmc_dtosc or
Selectr * from gencaram_prediction_data in sql
Data gets returned.. But for some reason it doesn't return data when I use the view in a form. What can I be doing wrong..
The only time data is returned in forms is when I sika28 has been granted select directly on the table.
Any suggestions.
Thanks
|
|
|
|
| Re: Using a view to populate data block - [message #143884 is a reply to message #143654] |
Sun, 23 October 2005 23:51  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Please confirm that you have given the role 'gencaram_user' 'select' access to the view 'GENCARAM.DMC_INPUT_VIEW'.
When you use SQL*Plus as a 'gencaram_user' can you do a 'select * from DMC_INPUT_VIEW'?
You say| Quote: |
In forms I create a datablock to display a.mmc and b.nomenclature
|
In Forms Builder, can the 'block' wizard 'see' DMC_INPUT_VIEW?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
