Skip to Content (Press Enter)
UserImage.jpg
Jessica Lee
118Views
5Comments
Solved
[How To Execute Stored Procedures] Does it work in Oracle?
Question
Forge
how-to-execute-stored-procedures
Web icon
How To Execute Stored Procedures (O11)
Forge asset by Guilherme Pereira

As my external database is Oracle, does this forge be workable?

If yes, may you instruct how to do it?

0
0
27 Aug 2020
Copy Link
2022-02-28 05-37-25
Ronny
Solution

Hi Jessica,

I think you can use 2 ways

1. Oracle REST Data services

2. Use some Application layer eg Java, .Net to build REST API that call the store proc

See solution in context
0
0
27 Aug 2020
Copy Link
2022-02-28 05-37-25
Ronny

Hi Jessica,

in my case, I created a REST API for the stored procedures in the external oracle database. My outsystems application will consume the REST API.

Hope that helps.

0
0
27 Aug 2020
Copy Link
UserImage.jpg
Jessica Lee

Hi Ronny,

May you provide me more how to recreate REST API for stored procedures? I haven't any ideas how to do it.

Thank in advance

0
0
27 Aug 2020
Copy Link
2022-02-28 05-37-25
Ronny
Solution

Hi Jessica,

I think you can use 2 ways

1. Oracle REST Data services

2. Use some Application layer eg Java, .Net to build REST API that call the store proc

0
0
27 Aug 2020
Copy Link
UserImage.jpg
Jessica Lee

Thank Ronny.

Let me try.

0
0
27 Aug 2020
Copy Link
2012-10-08 11-59-27
Guilherme Pereira
Staff

Hi Jessica,


For Oracle (and even for sql server) the recommended and supported approach is to use the RuntimePublic.Db api For which you can find documentation here


cheers,

Guilherme

0
0
27 Aug 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.