Exposing API VS Stored Procedure
-
>Hi, I have a Oracle DB in which all the information is stored and this information is been consumed by different teams and below is the two options i have to decide on : 1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure. 2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team. Like to know what is the PRON and CRONS with these options and what is the best possible solution to go with. Thanks
-
>Hi, I have a Oracle DB in which all the information is stored and this information is been consumed by different teams and below is the two options i have to decide on : 1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure. 2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team. Like to know what is the PRON and CRONS with these options and what is the best possible solution to go with. Thanks
-
>Hi, I have a Oracle DB in which all the information is stored and this information is been consumed by different teams and below is the two options i have to decide on : 1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure. 2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team. Like to know what is the PRON and CRONS with these options and what is the best possible solution to go with. Thanks
Java Lead wrote:
1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure.
Callers of the Stored Procedure will need direct access to the Oracle DB.
Java Lead wrote:
2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team.
This gives you the most control over the situation and is likely to be the most secure.
There are only 10 types of people in the world, those who understand binary and those who don't.
-
>Hi, I have a Oracle DB in which all the information is stored and this information is been consumed by different teams and below is the two options i have to decide on : 1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure. 2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team. Like to know what is the PRON and CRONS with these options and what is the best possible solution to go with. Thanks
The second option is better than the first one if different teams are working.