hiding the username/password@db from the url while running 10g report

70 pts.
Tags:
Oracle 10g
Oracle 10g Database
Oracle Reports
Oracle Reports 10g
iam running reports from developer 10 g release 1 using web.show_document command ,my application serves multi users that means each user has his own database user and password , so adding the key method in the cgicmd.dat will not help like :

userlogin : destype = cache desformat=HTMLCSS userid=scott/tiger@orcl %

 So, can I run report without showing the userid in URL?

 

 









Software/Hardware used:
developer 10g release1 , deployed on Oracle Application Server 10g

Answer Wiki

Thanks. We'll let you know when a new response is added.

You could do it this way:

-Create a REPORT object in your form (object navigator)
-Call the RUN_REPORT_OBJECT built-in procedure
-Show the rerport using web.show_document

Here’s an example (assumming that the report object was already created):

<pre>declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT(‘REPORT1′);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘repsrv’);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML’);
<b>v_rep := RUN_REPORT_OBJECT(repid);</b>
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in (‘RUNNING’,’OPENING_REPORT’,’ENQUEUED’)
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = ‘FINISHED’ THEN
/*Display report*/
<b>WEB.Show_Document</b>(‘/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_’,-1)+1)|| ‘?destype=cache&desformat=pdf/html&server=’ || ‘repsrv’, ‘_blank’);
ELSE
message(‘Error…’);
END IF;
END;</pre>

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • K1970
    i have examined the solution you suggested but the followinf error message has been appeared: frm-41213 : unable to connect to report server repsrv
    70 pointsBadges:
    report
  • carlosdl
    In the example above, 'repsrv' is the name of the report server. You should change it to your report server's name.
    69,510 pointsBadges:
    report
  • K1970
    thanks , the solution you gave me succeded but i don't want the result as pdf file i want as an ordinary previewer , i tried to replace the pdf/html with HTMCSS but it gave me the same pdf file, so how i can make it
    70 pointsBadges:
    report
  • carlosdl
    Sorry for late response. I overlooked this. Try setting the DESFORMAT parameter to the report object to HTML:
    SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'HTML');
    and don't include this parameter when showing the report:
    WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?server=repsrv', '_blank');
    This should generate an html report.
    69,510 pointsBadges:
    report
  • Nharisri
    Hi Sir, Try setting the DESFORMAT parameter to the report object to HTML: SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML‘);and don’t include this parameter when showing the report: WEB.Show_Document(’/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_',-1)+1)||’?server=repsrv’, ‘_blank’);This should generate an html report. Above one is working but how to send parameters to report? Report is generating blank. Thanks & Regards, Hari
    10 pointsBadges:
    report
  • carlosdl
    Hi Nharisri, To send parameters to the report you would have to create a parameter list, add the desired parameters to that list, and use the list when executing RUN_REPORT_OBJECT to call the report. Something like this:
    DECLARE
    	List_id ParamList; 
    BEGIN
    	List_id := Create_Parameter_List('input_params'); 
    	Add_Parameter(List_id, 'CITY',TEXT_PARAMETER,'PARIS'); 
    	Add_Parameter(List_id, 'CATEGORY',TEXT_PARAMETER,'EXPORTS');
    
    ...
    ...
    
    	v_rep := RUN_REPORT_OBJECT(repid,List_id);
    
    ...
    
    END
    69,510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following