Oracle SQL in 2.6

awillson · March 15, 2011 6:35AM

trying to execute the following SQL in 2.6

variable rc refcursor
exec sp_SLA_Extract('01 Mar 2011','Assignments',:rc)
print rc

This is via a direct Oracle db connection, connectivity all ok. This code has been testing in SQLPlus and execute an SP on the oracle DB with successful result.

Please advise how this is executed in Omniscope

chris · March 15, 2011 8:18AM

Hi,

Thanks for your comment.

Could you provide a bit more detail about your SQL statement? What is the result of executing the SQL? Is a table returned? Is the table generated 'In memory'?

At the moment Omniscope only supports retrieval of data using a SQL SELECT statement. It is possible to create a stored procedure that can be queried as if it was a table using a SELECT statement. An example of this can be found at:

http://stackoverflow.com/questions/101033/how-to-return-multiple-rows-from-the-stored-procedure-oracle-pl-sql

Welcome!

Categories

Ideas Parade