Re: Problem with views

mike wrote:

> I've got a report that I'm trying to run from the command line. In the
> report, it takes several input parameters and creates a view during the
> running of the report.
> Problem is that when I execute the command line, it connects to the
> database and runs the report, but won't generate the view. Hence, I get
> a blank page printed out.
> However, if I run the report from the runtime window (rwrun60) it works
> fine. Then I can go back and successfully run the command line, because
> the view now exists. This is running on Win2000.
> If anyone can PLEASE offer any suggestions, I will immediately and
> forever grant you God-like status (in my eyes anyway)! ;-)
> Thanks.
> -mike-

Please tell me that you learned databases with MS SQL Server and are new to Oracle.

This is no way to work with a view.

Create the view as a permanent object in the database and leave it there. If you can't do that then you are using the wrong solution for the problem at hand.

View on-the-fly can be built using dynamic SQL but that doesn't mean you should do it. I wonder whether a global temporary table might be a better solution though for a report ... I don't understand why you can't go directly to the tables.

And please keep the God-like status for someone deserving: Though they surely haven't shown up yet.

Daniel Morgan Received on Wed May 22 2002 - 15:24:38 CDT