RUN_PRODUCT(reports, 'Mingguan2_new.rep', SYNCHRONOUS, RUNTIME, FILESYSTEM, PL_ID, NULL);
the default it run to oracle database user "pbb/pbb@sismiop" but also i wanna run it to "pbb2/pbb2@sismiop"
RUN_PRODUCT(reports, 'Mingguan2_new.rep pbb2/pbb2@sismiop', SYNCHRONOUS, RUNTIME, FILESYSTEM, PL_ID, NULL);
but it not work.
Will any expert give some advise on this? Or Do you have any idea to call the report from db?
Thank you in advance!
RUN_PRODUCT takes the connection (username/password@database) of the user that is currently logged in in Forms.
Once the Reports Background Engine is started, it will re-use this connection to the database. So, even if you close Forms and login again with another username, a report will run as the previous logged in user. The user has to close the Reports Background Engine before running a report as a different user.
So, you need to specify what your problem is, not how to achieve the solution you think is the answer to your problem. What exactly is the problem you need to solve?
the real problem is i have two database one in window 2003 and another one in linux centOS, when i run my application and running report its ok (to database on window 2003), but when i run my application and running report its appear login form again (to database on linux centos). why it happened?