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!
Are you able to update the driver? There was a bug with some of the
Oracle drivers.
Igal Sapir
Lucee Core Developer Lucee.orghttp://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!