Uploaded image for project: 'Lucee Development'
  1. LDEV-1147

cfstoredproc fails with parameters when called by synonym which contains #


    • Type: Bug
    • Status: Deployed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s:
    • Fix Version/s:,
    • Labels:
    • Environment:

      Driver: Lucee Oracle Extension 12c (version
      Oracle: Database version 11 (Enterprise/Express)

    • Sprint:
      March 2018


      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!


        1. datasource-LDEV1147.log
          2 kB
        2. full-log-martin.txt
          10 kB
        3. LDEV1147-datasource.log
          10 kB
        4. LDEV-1147-output.pdf
          571 kB
        5. LDEV-1147-run-martin.pdf
          1.53 MB
        6. LDEV-1147-test.cfm
          3 kB
        7. LUCEE_BUG_TEST.sql
          0.3 kB
        8. screenshot-1.png
          46 kB
        9. screenshot-2.png
          111 kB
        10. screenshot-3.png
          119 kB
        11. screenshot-4.png
          119 kB
        12. stored-proc-param_blank.cfm
          1 kB
        13. stored-proc-param_blank (7fa0480b-3df4-4296-9fc2-0e3bb84b2329).cfm
          1 kB

          Issue links



              • Assignee:
                21solutions Igal Sapir
                martin MartinF
              • Votes:
                0 Vote for this issue
                7 Start watching this issue


                • Created: