perl.dbi.dev...Re: Sort hash keys in C... by Tim Bunce- May 26, 2008 On Sat, May 24, 2008 at 02:47:47PM +0100, Rudolf Lippan wrote:> On Mon, 19 May 2008 10:15:26 +0100, Tim Bunce <Tim.Buncepobox.com> wrote:> > I changed the code to use a struct (although I just threw the declaration> in ).> It makes it cleaner and gets rid of the sv_2mortal&39;d copy of the keys.> > Whatever seems reasonable (and best for ShowErrorStatement usage).>> I went and had the wrapper unSVify the params and call _join_hash_sorted().> This way there is.http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5374.html Re: Sort hash keys in C... by Rudolf Lippan- May 24, 2008 On Mon, 19 May 2008 10:15:26 +0100, Tim Bunce <Tim.Buncepobox.com> wrote:> > On Fri, May 16, 2008 at 01:45:51AM +0100, Rudolf Lippan wrote:>> On Thu, 15 May 2008 13:21:34 +0100, Tim Bunce <Tim.Buncepobox.com>> wrote:>> > It would be good to add a clear comment somewhere that the pointers in>> > the keys array are only valid until perl next free mortal temps.>> > (There are faster ways of doing that but the use case for the numeric>>...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5373.html Re: Memory leak in DBI by Tim Bunce- May 23, 2008 I&39;m sorry for the delay replying.On Thu, Apr 10, 2008 at 05:00:57PM +0200, Philippe Bruhat (BooK) wrote:> On Thu, Apr 10, 2008 at 03:40:55PM +0100, Tim Bunce wrote:> > I trust the script is destroying the results and, where appropriate,> > the $sth before calling Devel::Leak::CheckSV.> > Yes.> > The command is run in a block, with lexicals (except the $dbh).> To avoid counting information that is retained by the DBI, the command> is run twice, and the leak...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5372.html Re: Function Calling Methods by David E. Wheeler- May 21, 2008 On Wed, 14 May 2008 10:05:22 -0700, Martin Evens wrote:> That is slightly more complicated than it looks. DBD::Oracle already > magics a sth into existence for reference cursors but some databases > can return more than one result-set from a procedure - e.g., SQL > Server and the SQLMoreResults call to move to the next one.Huh. How interesting.I&39;m sure it&39;s more complicated than it looks, to be sure, but I was just trying to provide an 80% solution for simple functions...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5371.html RE: Bug in DBD::Oracle handling LOB columns and synonyms by mirko.kraft- May 21, 2008 Hi John,the Web interface doesn&39;t work for me, so I cc this to bug-DBD-Oracleat rt.cpan.org which should also be ok.I attached a diff -c on oci8.c from 1.21 which I think fixes the issue(not tested currently, however): oci8.c.ori Wed May 21 12:09:48 2008--- oci8.c Wed May 21 12:16:08 2008 2811,2816 --- 2811,2819 ---- lob_refetch_t lr = NULL; STRLEN tablename_len; char tablename;+ ifdef OCI_ATTR_OBJ_NAME not in 8.0.x + char new_tablename100;+ endif OCI_ATTR_OBJ_NAME.http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5370.html Re: Problems building DBD on strawberry Perl by Martin Evans- May 21, 2008 H.Merijn Brand wrote:> On Wed, 21 May 2008 09:21:57 +0100, Martin Evans> <martin.evanseasysoft.com> wrote:> >> Hi,>>>> I&39;m hoping someone here may be able to help with an outstanding ticket I >> have for DBD::ODBC.>>>> http:rt.cpan.orgDistDisplay.htmlStatus=Active&Queue=DBD-ODBC>> which started at http:rt.cpan.orgTicketDisplay.htmlid=32789 (for >> strawberry perl)>>>> The problem is people using cpan -i on...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5369.html Re: Problems building DBD on strawberry Perl by H.Merijn Brand- May 21, 2008 On Wed, 21 May 2008 09:21:57 +0100, Martin Evans<martin.evanseasysoft.com> wrote:> Hi,> > I&39;m hoping someone here may be able to help with an outstanding ticket I > have for DBD::ODBC.> > http:rt.cpan.orgDistDisplay.htmlStatus=Active&Queue=DBD-ODBC> which started at http:rt.cpan.orgTicketDisplay.htmlid=32789 (for > strawberry perl)> > The problem is people using cpan -i on strawberry perl as cpan sets INC > on the command line and this overrides any.http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5368.html Problems building DBD on strawberry Perl by Martin Evans- May 21, 2008 Hi,I&39;m hoping someone here may be able to help with an outstanding ticket I have for DBD::ODBC.http:rt.cpan.orgDistDisplay.htmlStatus=Active&Queue=DBD-ODBCwhich started at http:rt.cpan.orgTicketDisplay.htmlid=32789 (for strawberry perl)The problem is people using cpan -i on strawberry perl as cpan sets INC on the command line and this overrides any changes made to INC in the Makefile.PL. As a result the change all DBDs make to add the path for DBI&39;s header files is lost and the...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5367.html Re: Bug in DBD::Oracle handling LOB columns and synonyms by scoles- May 20, 2008 Ok I will have a look at it and you are right the code does not look quiteright.Do you think you can raise a ticket for this athttp:rt.cpan.orgPublicDistDisplay.htmlStatus=Active&Name=DBD-Oraclethat way I can track it better.You do not happen to know what the orginal starting line number was in oci8cheers John SColes> Hi ,> I&39;m using DBD::Oracle (code checked onCPAN and verified in version 1.21)> and encountered a problem (DB is Oracle 10gR2) related to LOBs and>...http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5366.html Bug in DBD::Oracle handling LOB columns and synonyms by mirko.kraft- May 20, 2008 Hi ,I&39;m using DBD::Oracle (code checked onCPAN and verified in version 1.21) and encountered a problem (DB is Oracle 10gR2) related to LOBs and synonyms:Table TTHUMBNAIL (DOCUMENT_ID NUMBER(12), THUMBNAIL BLOB NOT NULL) is owned by user DMSSGADM. User DMSSGDP has a synonym TTHUMBNAIL on the table and all necessary rights granted.When executing the following code$sthInsertTTHUMBNAIL = prepareStatement($dbh, &39;INSERT &39; . .http://www.nntp.perl.org/group/perl.dbi.dev/2008/05/msg5365.html |