Hi , Is it possible to execute Oracle Database Stored Procedure in Azure Data Factory and output as a CSV File? The Stored Procedure tool seems only available for SQL Server Connection.

Hello @KnowledgeSeeker and thank you for your question. While the Copy Activity option to select Stored Proc may not exist for Oracle table dataset the same way it exists for SQL, there is something you can try. In the Copy Activity "Use query" option where you can select "table" or "query", when you select "query" there is a space to write your own query statement. In this space you can write anything. Try writing an Execute stored proc statement here. Please let me know if this solves your issue.

AZURE DATA FACTORY - Oracle Database

Accepted answer

MartinJaffer-MSFT 26,081 Reputation points

2020-06-02T21:27:40.29+00:00

Hello @KnowledgeSeeker and thank you for your question.

While the Copy Activity option to select Stored Proc may not exist for Oracle table dataset the same way it exists for SQL, there is something you can try.

In the Copy Activity "Use query" option where you can select "table" or "query", when you select "query" there is a space to write your own query statement. In this space you can write anything. Try writing an Execute stored proc statement here.

Please let me know if this solves your issue.
Please sign in to rate this answer.
KnowledgeSeeker 21 Reputation points

2020-06-03T05:23:13.47+00:00

Hi Majaffer,

Thank You for your suggestion,

May I know, what about the dataset, it only allow as to choose table.

or do we choose any table which acts a dump table.

MartinJaffer-MSFT 26,081 Reputation points

2020-06-05T00:21:13.527+00:00

I do not think the table in the Dataset should make any difference as long as you choose query in the Copy Activity. Query overrides the table because when writing a SELECT stuff FROM MyTable you specify the table right in the query.

KnowledgeSeeker 21 Reputation points

2020-06-06T10:56:09.74+00:00

Thanks @majaffer , its works for table .
Just wonder for Stored Procedure, by writing (Exec SP_Name;) query , will it work? . Or required additional query or schema name in the query.

Chawla, Charu [PHSA] 1 Reputation point

2020-11-20T19:48:03.887+00:00

Just wondering, the above approach works or not?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

AZURE DATA FACTORY - Oracle Database

0 additional answers

Your answer