DO NOT REPLY [Bug 37664] New: - apr_dbd_oracle.c parameter and output handling

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=37664>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=37664

           Summary: apr_dbd_oracle.c parameter and output handling
           Product: APR
           Version: HEAD
          Platform: All
        OS/Version: All
            Status: NEW
          Keywords: PatchAvailable
          Severity: major
          Priority: P2
         Component: APR-util
        AssignedTo: bugs@httpd.apache.org
        ReportedBy: chrisd@pearsoncmg.com
                CC: chrisd@pearsoncmg.com


Some patches for apr-util/trunk/dbd/apr_dbd_oracle.c, based on
testing and initial production usage.  More to come, no doubt!  :-)

- replaced leftover dbd_oracle_lob_size() declaration with
  native dbd_oracle_long_size_set() function

- dbd_oracle_query() uses a private pool to ensure that both Stmt and
  LOB callback cleanups are performed

- in dbd_oracle_prepare():
  - don't count %% towards nargs

  - don't attempt to support native Oracle params (e.g., :foo)
    because we get fooled by SQL like TO_DATE(sysdate, 'HH:MM:SS')

  - calculate length for orastr using maximum param length (:aprNNN...),
    and add trailing '\0' for strlen(orastr)

  - no need to iterate through orastr when calling OCIBindByPos(),
    and avoids false detection of native params in SQL like
    TO_DATE(sysdate, 'HH:MM:SS')

  - always register freeStatement callback against pool; assumption
    is that pool passed to dbd_oracle_prepare() lasts as long as
    prepared statement will be retained

  - for output params, handle common data types according to
    "Perl standard" :-)

- in dbd_oracle_get_entry():
  - removed USE_LOB_LOCATOR ifdef

  - added handling for LVC/LVB long structures

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org