cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Can we run Oracle Stored procedure using custom 2.0 sql data source extension?

susmita_ally
Contributor

Can we run Oracle Stored procedure using custom 2.0 sql data source extension?

1 REPLY 1

Mike_L
Dynatrace Guru
Dynatrace Guru

Due to security implications of stored procedures being able to perform tasks such as drop tables and inserts, the data source is limited to select statements.

Try to extract the query from the stored procedure into a select statement, either directly, or by scheduling a job on the server which drops the result of the stored procedure into a single table.

Mike

Featured Posts