Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Data Sets -> Generate SQL Views
Data Sets -> Generate SQL Views [message #1836333] Tue, 29 December 2020 11:21 Go to next message
ewr2345235 45646 is currently offline ewr2345235 45646Friend
Messages: 1
Registered: December 2020
Junior Member
Hello, I want to generate a Report form a very simple DataSet Query:

select * from CombinedViewOrdered
where "SAMPLE" is not null;

But the Problem is that every time I want to run the Report the ORACLE SQL View
"CombinedViewOrdered" has to be recreated (replaced)

And this View depends on another view called "CombinedView" that needs to be also recreated before I do my 'select' Query.

My Database User is allowed to create and replace views and to do selects, but NOT to execute stored procedures.

In an ORACLE SQL Development Environment I would just execute a single *.sql File that contains the statements that create the multiple views and then do the select at the end.

Now I am looking for the same way in BIRT Reporting Tool.
Basically every time when I create my Result Set with my Data Set I want that the views are replaced beforehand ( this needs to be executed by the BIRT reporting tool with the existing permissions of the Data Source)

How can I do that ?

Thanks in advance

Re: Data Sets -> Generate SQL Views [message #1836394 is a reply to message #1836333] Fri, 01 January 2021 15:03 Go to previous message
rbaak Mising name is currently offline rbaak Mising nameFriend
Messages: 31
Registered: July 2009
Sounds like you need to negotiate the use of that stored procedure. Other work arounds would be potentially to long and hard to manage long term.

Previous Topic:birt sql add hour
Next Topic:Nobody has tries to use Birt with Scriptcase Php framework ?
Goto Forum:

Current Time: Fri Jun 02 16:33:59 GMT 2023

Powered by FUDForum. Page generated in 0.02008 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top