Wonderful! Thanks. On Thu, Sep 12, 2002 at 06:08:09PM -0700, Michael A Chase wrote: > Add ORA_STRING and ORA_CHARZ to :ora_types so all four valid values for > ora_ph_type are available as symbolic constants. This seemed reasonable > since the ora_type values and the ora_ph_type values are both used to set > ftype. > > Add :ora_ses_modes so ora_session_mode can be set with a symbolic constant. > > Document ora_ph_type.
Can someone confirm for me that this works as advertised? > Document ora_type. It's shown all over the place, even in DBI.pm, but > there was no section describing it. > > Add a pointer to CPAN Search in "SEE ALSO". I frequently want to point > people to Oracle.ex/, but if they installed using ActiveState PPM, they > don't have a copy of that directory where they can look at it. > > Remove some Todos. I think there are a couple more that can go, but I'm > not sure enough to do it. > > I considered documenting prepare() attributes ora_parse_lang, ora_auto_lob, > and ora_check_sql, but I wasn't sure if you wanted them exposed yet. That's fine. Funnily enough I've just been talking with Gary Milsop of Hotsos about ora_check_sql and will probably add a $dbh attribute to allow the default to be changed per handle. (Setting ora_check_sql=0 avoids a parse step within the server and can thus have a significant performance boost, but there are some downsides, see google for details.) > +=item ora_type > + > +Specify the placeholder's data type using an Oracle data type. > +A fatal error is raised if C<ora_type> and the DBI C<TYPE> attribute > +are used for the same placeholder. > +Some of these types are not supported by the current version of > +DBD::Oracle and will cause a fatal error if used. > +Constants for the Oracle datatypes may be imported using > + > + use DBD::Oracle qw(:ora_types); > + > +Meaningful values when DBD::Oracle was built using OCI 7 and later: > + > + ORA_VARCHAR2, ORA_STRING, ORA_NUMBER, ORA_LONG, > + ORA_ROWID, ORA_DATE, ORA_RAW, ORA_LONGRAW, > + ORA_CHAR, ORA_CHARZ, ORA_MLSLABEL, ORA_RSET I'll remove ORA_NUMBER, ORA_ROWID, and ORA_DATE from the docs because they don't do what people might expect them to. Thanks again Michael. Tim.
