Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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
