Toad World® Forums

Using Oracle Functions in Cross Connect Query


#1

I’m having some trouble getting a cross connect query to work. Both connections are Oracle, but different Oracle connections. I’m trying to write a cross connect query but am getting an error that a function I am using in one of the queries is not supported by cross connect. I’ve even tried saving each query as a view and joining that way with no luck. The function is the listagg function in Oracle. Looking for some guidance or ideas here.


#2

Hi Tony,

The cross query engine uses MySql engine and so only MySql functions are supported.

Regards

Aleksey


#3

That’s unfortunate, but thanks for the info.

On Tue, Aug 12, 2014 at 1:20 PM, Aleksey Bazhenov bounce-AlekseyBazhenov@toadworld.com wrote:

RE: Using Oracle Functions in Cross Connect Query

Reply by Aleksey Bazhenov
Hi Tony,

The cross query engine uses MySql engine and so only MySql functions are supported.

Regards

Aleksey

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag this post as spam/abuse.


#4

Tony - if you haven’t come up with another solution, ask your DBA to create a DB Link between the Oracle databases - this allows you to access data from one Oracle DB from another Oracle DB - including joining tables together, etc.