All my data is stored within Oracle and tables are versioned by database design.
All Database operations are implemented in PLSQL to ensure versioning as we do not allow update or delete of any content.
As i this I want to use those packages within OUT-System. Calling simple functions works with the select from dual trick but any method executing database operations don't work.
I do not want to put any of this logic to Outsystems as this shall be used also from other tooling.
Any hints to get this solved or do I need to change to Oracle APEX ;-)
There is also the need to get content (OUT Parameters) back into Outsystems.
we need to decided between Outsystems and Oracle Apex soon. Perhaps this will be a killer for OS.
Hello Jens
You can use the Oracle Connector P11 to connect to an Oracle database and execute stored procedures or functions.
https://www.outsystems.com/forge/component-overview/6636/oracle-connector-p11
Also, please note that OutSystems allows you to create extensions using C# code. This allows you to use all of the power of C# and then call that functionality from within your OutSystems application(s).
I hope all is well,
Jeremy
Thanks Jeremy,
are you aware of any examples for "OutSystems allows you to create extensions using C# code " to call oracle stuff?
For the extension I need to ask my Admins if it is OK to add those.
Hello Jens,
If you download the Oracle Connector I linked to above you can view the C# code that they used to create the connector. It should give you a lot of great information.
If you open the Oracle Connector in Integration Studio you can click the button circled in the screenshot to open Visual Studio so you can inspect the code.
Other than that, here is a link to the documentation on creating an extension.
https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/Extend_Logic_with_Your_Own_Code/Extension_Life_Cycle/Create_an_Extension
Once you get the stub for the extension designed in Integration Studio, you can just edit the code in Visual Studio like you would any traditionally coded application. You can add packages from NuGet, etc. Then you publish the extension from Integration Studio. From there you can add the extension as a dependency in your OutSystems application to expose the functionality from within the extension.
I hope this information helps.