[Lucee 5.1] Oracle Datasource with Synonyms

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 .() }

The exception is: PLS-00306: wrong number or types of arguments in call to
‘’

But in the 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

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.

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

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/On 1/5/2017 2:10 PM, ‘Martin Frstr’ via Lucee wrote:

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 .() }

The exception is: PLS-00306: wrong number or types of arguments in
call to ‘’

But in the 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

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+unsubscribe@googlegroups.com
mailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com
mailto:lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/214a5cf3-82f1-4502-9372-591233df811f%40googlegroups.com
https://groups.google.com/d/msgid/lucee/214a5cf3-82f1-4502-9372-591233df811f%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.

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

cheers,

Martin

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