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.

Are Stored Procedures (PL/SQL) Supported?

April 26, 2017PL procedures sql stored supported

0

Posted

Are Stored Procedures (PL/SQL) Supported?

1 Answer

0

Posted

Yes. The DataDirect Connect Series Oracle drivers fully support returning result sets (including multiple result sets) generated from PL/SQL stored procedures against 7, 8, 8i, 9i, and 10g servers. This implementation is: • Flexible-You can call any stored procedure without worrying about data integrity or the size of result sets. • Standards-based-Calling an Oracle stored procedure and returning a result set is done the same way it would be done for other databases, such as Informix or Sybase, and the way it would be expected by any third-party application. • Fully functional-Business logic written in PL/SQL is not limited to a single result set. Multiple result sets can be returned from a single invocation, which allows the greatest application flexibility and performance.