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

cfstoredproc fails when calling a procedure with parameters on Oracle with a specified schema

    Details

    • Type: Bug
    • Status: Deployed
    • Priority: New
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0.0.235, 4.5.3.015
    • Labels:
      None
    • Environment:

      Description

      If cfstoredproc is used to call a procedure with parameters within an Oracle package, it fails if you try to specify a schema name. The error returned is:

      ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TESTPROC' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
      calling lucee_bug_test.testfunc

      This only happens when a schema is specified and only occurs if parameters are passed to the procedure. It may be a problem with the way lucee handles the extra dot when parsing the package/procedure name.

      An example of code that triggers this bug (note the schema name that prefixes the package):

      <cfstoredproc procedure="myschema.mypackage.myproc" datasource="#ds#" username="#dsUser#" password="#dsPass#">
      <cfprocparam cfsqltype="cf_sql_varchar" value="foo">
      </cfstoredproc>

      The following code would not trigger this bug as no schema is specified:

      <cfstoredproc procedure="mypackage.myproc" datasource="#ds#" username="#dsUser#" password="#dsPass#">
      <cfprocparam cfsqltype="cf_sql_varchar" value="foo">
      </cfstoredproc>

      The attached files demonstrate this bug.

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                michaeloffner Michael Offner
                Reporter:
                mjs510 Max Spicer
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: