Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling stored proc with multi tiered layers

Status
Not open for further replies.

satinsilhouette

Instructor
Feb 21, 2006
625
Got a question.

A report has two subreports. The report calls a stored procedure. the stored procedure has parameters that are shown in CR. You have to answer these parameters before the stored proc will run.

The first parameter is asking for the userid again afer having logged into BOE and that userid and password have already been verified against the database.

Someone mentioned that passing a parameter back to Oracle via CR might have some sort of parameter leak because it is two-tiered or three-tiered.

Has anyone run across this before? The user should not have to pass back their user id agan.

CRXI R2, ORACLE 10G

Thanks so much!
satinsilhouette
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top