When executing procedures via synonyms which contain # Lucee does create a SQL statement without parameters and therefore Oracle responds with the following exception:
PLS-00306: wrong number or types of arguments in call to 'TESTPROC2' ORA-06550
Generated SQL: call BU#.testproc2()
The attached test includes the SQL to generate the package with 2 procedures and a synonym for the package.
Calling the package by normal name succeeds for calls with and without parameters. Calling the package by synonym succeeds for calls without paramaters. Calls by synonym with parameter fail with the above exception.
This is an isolated test case and i could reproduce it on Oracle Express 11. The behaviour for Oracle Enterprise is the same.
The test is build upon the test case of the related bug ( LDEV-637 Deployed ).
Related google group post:
Any help is appreciated. Thanks in advance!