OAS- How to Execute SQL Stored Procedures from Data Visualization Manual Query to Create a Dataset

Question

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.

Steve F-2 · Answer

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.

https://www.ateam-oracle.com/post/using-stored-procedures-as-a-source-for-oracle-analytics

Other comments, welcomed.