https://community.dynatrace.com/t5/Extensions/Can-we-run-Oracle-Stored-procedure-using-custom-2-0-SQL-data/m-p/246241#M4454 <P>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.</P> <P>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.</P> Tue, 21 May 2024 21:55:27 GMT Mike_L 2024-05-21T21:55:27Z https://community.dynatrace.com/t5/Extensions/Can-we-run-Oracle-Stored-procedure-using-custom-2-0-SQL-data/m-p/246240#M4453 <P>Can we run Oracle Stored procedure using custom 2.0 sql data source extension?</P> Mon, 19 Aug 2024 11:56:45 GMT https://community.dynatrace.com/t5/Extensions/Can-we-run-Oracle-Stored-procedure-using-custom-2-0-SQL-data/m-p/246240#M4453 susmita_k 2024-08-19T11:56:45Z https://community.dynatrace.com/t5/Extensions/Can-we-run-Oracle-Stored-procedure-using-custom-2-0-SQL-data/m-p/246241#M4454 <P>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.</P> <P>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.</P> Tue, 21 May 2024 21:55:27 GMT https://community.dynatrace.com/t5/Extensions/Can-we-run-Oracle-Stored-procedure-using-custom-2-0-SQL-data/m-p/246241#M4454 Mike_L 2024-05-21T21:55:27Z