Doctrine 1
  1. Doctrine 1
  2. DC-1008

missing oci_type in Doctrine_Adapter_Statement_Oracle->bindParam

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query
    • Labels:
      None

      Description

      in bindParam method there is:
      switch ($type) {
      case Doctrine_Core::PARAM_STR:
      $oci_type = SQLT_CHR;
      break;
      }
      I think there should be other oci_types too. I had to add:
      case Doctrine_Core::PARAM_INT:
      $oci_type = SQLT_INT;
      because I got ORA-06502: PL/SQL: numeric or value error: character string buffer too small. while executing
      $stmt->bindParam(":result", $result, Doctrine_Core::PARAM_INT);

      After adding SQLT_INT everything is ok

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Guilherme Blanco
            Reporter:
            Tomasz Madeyski
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: