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

cfstoredproc fails with parameters when called by synonym which contains #

    Details

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

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

    • Sprint:
      March 2018

      Description

      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:
      https://groups.google.com/forum/#!topic/lucee/UCwt4FFExX8

      Any help is appreciated. Thanks in advance!

        Attachments

        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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: