[Lucee 5.1] Oracle Datasource with Synonyms

[Martin Frstr]

Hey Guys,

I have installed Lucee 5.1 with the newest available Oracle Datasource extension for Lucee. Database connections is working without problems, also queries and most procedures. But all procedurs that are called via synonym fail with the following sql statement:

{ call <synonym name>.<procedure>() }

The exception is: PLS-00306: wrong number or types of arguments in call to '<procedure>'

But in the <cfstoredproc> statement a IN paramater is defined and it is working in AFC.

I saw the same error for normal procedures earlier when working with Lucee 4.5.1 and it was fixed in 4.5.3. In general there is nothing special with the notation of synonyms in comparison to ordinary package call, only difference for us is, that we use # in the name of the synonym, which seems to break the parser and not add parameters.

I would really appreciate some help, since we want to move from AFC to Lucee. But this problem is a show stopper right now. Thanks in advance for your help!

cheers,

Martin

[Igal @ Lucee.org]

Are you able to update the driver?  There was a bug with some of the Oracle drivers.

Igal Sapir
Lucee Core Developer
Lucee.org

--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/214a5cf3-82f1-4502-9372-591233df811f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Martin Frstr]

Hi Igal,

thanks for the fast answer!

I took the newest driver from here:

http://stable.lucee.org/download/?type=extensions

Which is this one:

http://extension.lucee.org/rest/extension/provider/full/D4EDFDBD-A9A3-E9AF-597322D767E0C949?version=12.1.0.2

And installed it manually via upload.

[Igal @ Lucee.org]

Yes, 12.1.0.2 seems to be the most recent driver:  http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

This was the old bug:  https://luceeserver.atlassian.net/browse/LDEV-637

If you can create a reduced (i.e. minimal) reproducible test case then please open a new ticket and reference LDEV-637 in it.  Perhaps there have been some regression somewhere, or there is an edge case that was not accounted for.

Igal Sapir
Lucee Core Developer
Lucee.org

--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/4b281696-9b6a-4723-a78d-3d6620984ee4%40googlegroups.com.

[Martin Frstr]

Thanks for your answer. I will prepare the test case!

cheers,

Martin

[Martin Frstr]

Bug created: https://luceeserver.atlassian.net/browse/LDEV-1147