Hi, I have oracle report 6i and database as Oracle 9i. I want to run oracle report from a stored procedure or function. In the thread you talked about SRW package but I can not use it on Oracle 9i DB. Please provide me some guidelines for it.
may be all what is mentioned in this thread is valid ... but there'a a API available to call Reports out of the database via PL/SQL. Look at the *"Event driven Publishing"*
You can't. You have to use one special user that has select privilege on all tables.
It works just like most web applications: there is only one database user that connects (e.g. via jdbc) from the application server to the database. The application itself has to keep track of which application user is allowed to run the report.