Eclipse Community Forums: Newcomers » BIRT database user access

Help

Home

Home » Newcomers » Newcomers » BIRT database user access

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT database user access [message #881874]

Tue, 05 June 2012 12:08

Daniel C

Messages: 4
Registered: June 2012

Junior Member

Hi guys,
I have a dataset which calls a procedure in the oracle database to access user@client, query as follows -

{call SI0WPR_SET_IDENTIFIER (?,?,?)}

where it takes a user, client and desc_client (output).

database procedure -

PROCEDURE "PE0WPR_SET_IDENTIFIER" ( in_userId varchar2 ,in_client varchar2 ,description out varchar2 ) AS

BEGIN

dbms_session.set_identifier(in_userId||'@'||in_client);

select distinct desc_client into description from sipe0wclienti where cod_client=in_client;

END PE0WPR_SET_IDENTIFIER;

The problem is that this method is not very efficient when i try to access tables through dynamic report parameters (lists) as it needs to access the dataset before executing the dynamic parameter.

Is there any way to pull this procedure into reportContext and initialise the report with the user access already granted to the database?

Thanks

Report message to a moderator