# Oracle PL/SQL

**URL:** <https://techcommunity.softwareag.com/t/oracle-pl-sql/59207>\
**Category:** Forum\
**Tags:** Mainframe-Integration, EntireX\
**Created:** [March 21, 2005, 9:30pm UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207 "2005-03-21T21:30:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![LaJuan](https://avatars.discourse-cdn.com/v4/letter/l/dc4da7/32.png) [@LaJuan](https://techcommunity.softwareag.com/u/LaJuan)\
**Post date:** [March 21, 2005, 9:30pm UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207/1 "2005-03-21T21:30:50Z")

</div>

Does Entire-X interface with oracle PL/SQL?

Our Internet support Staff uses the integrated Apache web server that comes with Oracle to provide dynamic web site content. I was asked the question above.

Does anyone have any suggestions on which components of EntireX would best be suited to use with Oracle PL/SQL? If there are examples available, please tell me where they are located.

Thanks

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [March 22, 2005, 12:39am UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207/2 "2005-03-22T00:39:29Z")

</div>

One option is to use the Java Wrapper and/or RPC server. For Oracle applications wanting data from mainframe (eg Natural / Adabas), a Java Wrapper client program would make an RPC call to Natural RPC server to return data. For Natural (or other mainframe client applications), Natural can call a Java RPC Server (see the Examples directory and SDK documentation), which invokes Java methods to do such things as accessing Oracle databases.

There is a Technical Paper on Servline24 on “RPC Testing” in the EntireX section that talks about calling the Java RPC Server from Natural.

---

<div class="post-metadata">

**Author:** ![LaJuan](https://avatars.discourse-cdn.com/v4/letter/l/dc4da7/32.png) [@LaJuan](https://techcommunity.softwareag.com/u/LaJuan)\
**Post date:** [March 22, 2005, 1:35am UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207/3 "2005-03-22T01:35:44Z")

</div>

Thank you. This information was very helpful.

---

<div class="post-metadata">

**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\
**Post date:** [March 28, 2005, 8:39am UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207/4 "2005-03-28T08:39:30Z")

</div>

Attached is a Java as well as a PL/SQL example, which a colleague of mine created a few years ago.

I hope you find it useful.

Theo  
[Oracle.zip](https://techcommunity.softwareag.com/uploads/short-url/xxpN6RcGyGGEtzIMEAAmeEc4VJK.zip) (38.5 KB)

---

<div class="post-metadata">

**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\
**Post date:** [March 28, 2005, 8:40am UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207/5 "2005-03-28T08:40:13Z")

</div>

And here is the second attachment.  
[PL SQL.zip](https://techcommunity.softwareag.com/uploads/short-url/c4vlHEG5NDjSRRIJi54qpmoRxCI.zip) (1.1 KB)

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:39pm UTC](https://techcommunity.softwareag.com/t/oracle-pl-sql/59207/6 "2021-04-02T14:39:42Z")

</div>