nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Is it possible to use Presentation variable values as input to a stored procedure in the RPD?

Chris Arnold

I'm trying to use a stored procedure in our RPD. I've managed to be successful at doing so.
My issue is... the stored procedure's input parameters will need to be entered by the user on a dashboard. I have NOT been successful in getting this done.

I see in this person's blog post (see below link) that the input parameters can be set by using Session variables or Repository variables -- but I think I'm needing the stored procedure to accept the values of Presentation variables. Is this possible?
http://obiee101.blogspot.com/2011/01/obiee-using-mssql-stored-procedure-as_10.html

Here is the syntax I've tried without success:
EXEC TestDataMart.TDM.usp_TestSPROC @StartDate = @{vStartDate}, @EndDate = @{vEndDate}

Find more posts tagged with

Accepted answers

[Deleted User]

Hi Chris,

You'll have to use request variables instead of presentation variables.

https://datacadamia.com/dat/obiee/obis/set_variable

All comments

[Deleted User]

Hi Chris,

You'll have to use request variables instead of presentation variables.

https://datacadamia.com/dat/obiee/obis/set_variable

Chris Arnold

Thank you!

[Deleted User]

Thank you for bringing up such a core functionality :) Underestimated and known far too little.