dynamic text from input value ??

mlotfi

I have a stored procedure :

procedure dw_get_all_roles_for_user
( AW_USER_ID IN osp$user.user_id%TYPE,
cur_generic IN OUT result_sets.cur_generic) is
...

it takes as input :
AW_USER_ID

and return :
Role_ID
Role_Name
Role_Type
Unit_Name

I want to have before the table that shows the returned columns a line that show :

All roles for the user ?????? what should I put here to have the AW_USER_ID show dynamically.

thanks

JasonW

Are you setting the parameter using an input parameter?

You should be able to reference the input parameter in an expression within the bound item by using this syntax:
inputParams["datasetparametername"]
See attached example.

Jason