Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I call the PL/SQL APIs from a Web Provider (Java) Portlet?

April 26, 2017APIs Java PL portlet Provider sql web

0

Posted

Can I call the PL/SQL APIs from a Web Provider (Java) Portlet?

1 Answer

0

Posted

You should be able to create a wrapper to call the Portal PL/SQL APIs. One issue that you may encounter if you create your own wrappers is that some of the PL/SQL APIs use PL/SQL datatypes (tables, records) for parameters or return values of functions. JDBC cannot handle these datatypes directly so you would need to create a PL/SQL wrapper to construct/deconstruct the PL/SQL data types into their basic Oracle datatypes (NUMBER, VARCHAR2). In the case of functions that return PL/SQL records (the most problematic case) a possible solution is to create an Oracle8 object or ADT that reflects the contents of the PL/SQL record and then pass that back to JDBC. You can use the Oracle extensions to JDBC for handling ADTs. In a future release, the Java API is to be extended to include many of the functions that can now be called only through the PL/SQL API.