Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Running ORE from PL/SQL

765466May 23 2017 — edited Oct 19 2017

Is it possible to run embedded R script from PL/SQL? All the examples are for SQL.

When I try to run SQL (embedded R) in PL/SQL, I get this error:

ORA-06550: line 2, column 37:

PL/SQL: ORA-22905: cannot access rows from a non-nested table item

ORA-06550: line 2, column 4:

PL/SQL: SQL Statement ignored

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

Code used:

begin

   select 1230000, 1, 123, val from table(rqTableEval(

    cursor(select 1,2,3 from dual),

    NULL,

    'select 1 val from dual',

    'PR12')

  );

end;

Working code:

select 1230000, 1, 123, val from table(rqTableEval(

    cursor(select 1,2,3 from dual),

    NULL,

    'select 1 val from dual',

    'PR12')

  );

# PR12 is just a simple function.

Thank you,
George

This post has been answered by rtiran on May 24 2017
Jump to Answer

Comments

Alex Keh-Oracle

Not in the near future. AQ support has been requested significantly fewer times than BulkCopy and UDTs for managed ODP.NET and ODP.NET Core. From a priority standpoint, those features are first.

User_BH2X3

Are there any updates regarding AQ support in .NET Core? The white paper about microservices published here https://www.oracle.com/a/tech/docs/caonbdcm-final.pdf includes java, python, javascript case studies. Wouldn't it be nice to have the latest C# option too?

Alex Keh-Oracle

Sorry, I don't have any update with a specific delivery timeline. We are working on AQ for ODP.NET Core, but it's not one of the higher requested features. When we finish up the next few planned ODP.NET Core releases, I'll have more visibility on a delivery timeline for ODP.NET Core AQ at the end of this year.

User_HN10Q

Hi,

Just adding a +1 for AQ support in ODP.NET Core ASAP!

We have a strong use case for an evolution of our core banking application to microservices.
Thanks,
Michael

User_6M868

Hey,

are there any news? I saw that there is a Kafka API wrapper for Java and Advanced Qeueing. Are there such plans for .net core as well?

Alex Keh-Oracle

The current thinking is Oracle will have managed and core ODP.NET AQ support in the second half of 2022. There are no plans for a Kafka wrapper at this time, but we'll see what the demand level for that is. Currently, the higher demand comes from being able to port unmanaged ODP.NET AQ to managed/core ODP.NET.

User_Q8RWH

Another +1 for AQ support for ODP.NET Core. Any updates?

Alex Keh-Oracle

ODP.NET AQ for core and managed are planned to be in-line with the next Oracle DB release. More details on when the next DB release will be available at Oracle Cloud World in October.

Leo Ferreira

any news on this front? im starting a project that could greatly benefit from this... specially if the client is backwards compatible with the 19c version of the database

Alex Keh-Oracle

Oracle CloudWorld is the week of October 17. ODP.NET AQ for core and managed ODP.NET availability will be discussed then.
Yes, these new ODP.NET AQ features will be backwards compatible with DB 19c.

Leo Ferreira

Any news?

Alex Keh-Oracle

As announced during Oracle CloudWorld, ODP.NET AQ (and Transactional Event Queuing) APIs in managed and core versions will be available when Oracle DB 23c is released. The Oracle DB 23c beta 1 was also made available last week.

Leo Ferreira

Couldn't find that announcement specifically, but that's great! Did they detailed backwards compatibility?

Alex Keh-Oracle

This particular session wasn't recorded to video. ODP.NET AQ for managed and core will be backwards compatible with DB 19c.

Leo Ferreira

Do I have to download the beta to get my hands on that or its available somewhere in nuget?

Alex Keh-Oracle

There's a 23c beta program. ODP.NET AQ is a part of it. Organizations will have to apply to join the beta. Here's more info how to join: https://blogs.oracle.com/database/post/oracle-database-23c-beta-program
When you fill out the application form, you can indicate interest in ODP.NET AQ by selecting “Event Processing” --> “Advanced Queuing and Transactional Event Queues Enhancements” in question 5.

User_6M868

Hi there,

Is there any news on this? I've just looked at the managed core driver, but I can't find any support for AQ.

Alex Keh-Oracle
Answer

Managed ODP.NET and ODP.NET Core will support AQ APIs starting with version 23c. We plan to have a developer release on NuGet Gallery very soon. These AQ APIs can be used with traditional AQ or Transactional Event Queues and with DB 19c and higher.

Marked as Answer by Alex Keh-Oracle · May 10 2023
Leo Ferreira

Any news here @alex-keh-oracle?

Alex Keh-Oracle

We released AQ and TxEventQ API support in July with managed ODP.NET and ODP.NET Core 23.2 dev releases. They can be downloaded from NuGet Gallery.

https://www.nuget.org/packages/Oracle.ManagedDataAccess/23.2.0-dev

https://www.nuget.org/packages/Oracle.ManagedDataAccess.core/23.2.0-dev

ODP.NET AQ doc has been updated to reflect the new support. If you are porting unmanaged ODP.NET AQ apps to managed/core, the experience should be relatively straightforward. Managed/Core have a superset of unmanaged ODP.NET capabilities.

If you have feedback on the dev release, let us know.

1 - 20
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 21 2017
Added on May 23 2017
1 comment
714 views