Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OAS- How to Execute SQL Stored Procedures from Data Visualization Manual Query to Create a Dataset
Arun Kumar Soundararajan-Oracle
Rank 2 - Community Beginner
I would like to reuse the existing SQL stored procedure to create reports in OAS DV. I'm getting error when running the SQL command (exec schema.StoredProcedureName) in the Manual query in DataSet.
0
Answers
-
It is not supported to directly call 'exec' in the manual query.
You can do it in the data model (RPD).
Search and up-vote an existing Ideas Lab request, or if none exists, then file a new one with your use-case.
Alternatively, you can see if this helps.
Other comments, welcomed.
1
