Hi,
Is it possible to create a view based on the output of a stored procedure? this output will be a recordset
This stored procedure will access a few tables, do some transformations on the data and this data should then be returned to Business Objects. Since Business Objects doesn't support PL/SQL, I was wondering if it is possible to create a view based on the stored proc's output? This view can then be used in Business Objects.
In the near-future, this information will be extracted via a Java app instead of Business Objects so we want to re-use this stored proc
Thanks a lot for your help,
-T
Is it possible to create a view based on the output of a stored procedure? this output will be a recordset
This stored procedure will access a few tables, do some transformations on the data and this data should then be returned to Business Objects. Since Business Objects doesn't support PL/SQL, I was wondering if it is possible to create a view based on the stored proc's output? This view can then be used in Business Objects.
In the near-future, this information will be extracted via a Java app instead of Business Objects so we want to re-use this stored proc
Thanks a lot for your help,
-T