How to get around Report Server Logon page?

[randall2nd]

How to get around Report Server Logon page?

I am trying to kick off a report in a trigger. I cannot use the event driven publishing, due to OS versions. So, I am trying to submit a job using UTL_HTTP. The report server has been setup to accept a job through a web page, I tested it and it works after going through a logon page.

I tried using the UTL_HTTP.request function passing in the same URL I used in the browser and output the response, only I do not seem to get a response. I am new to both reports and the UTL_HTTP pacakge. I can only guess that the reason I do not get a response, is that I am supposed to somehow logon to the report server, the page displayed when submitting through the browser.

Broweser URL --> displays "Reports Database user Authentication" page asking for username, password, database

http://reports.webserver.com/cgi-bi...e=file+desname=/tmp/reports/report1_scott.rep

Oracle procedure -->outputs nothing
CREATE OR REPLACE TEST_REP
AS
V_REQ VARCHAR2(2000);
V_URL VARCHAR2(2000);
BEGIN
V_URL := '

http://reports.webserver.com/cgi-bi...file+desname=/tmp/reports/report1_scott.rep';

V_REQ := UTL_HTTP.REQUEST(V_URL);
DBMS_OUTPUT.PUTLINE(TRIM(SUBSTR(V_REQ,1,200)));
END;


Did I do something wrong?
Has anyone done this before?
Are there extra parameters that I need to pass?
Any Ideas?

Randall2nd
Ignorance does not equal stupidity, do not treat it as such.

 

[randall2nd]

Well I figured it out myself.

Apparently I forgot to include the parameter "userid=scott/tiger@orcl", I thought "user" was handling that but apparently not.

Also just to let others know:
Using a keymap in the CGIcmd.dat file can hold all the parameters that are static, I just then include the parameter "cmdkey=Key1" as a parameter and the non-static paramters in the URL. Here are some links that discuss this info:

Discussion on keymaps to bypass log-on screen

Doc on Keymaps


Randall2nd
Ignorance does not equal stupidity, do not treat it as such.