I use this to alter my sessions:
$dbh->do( q( alter session set nls_date_format = '' ) );
Should work for the schema as well.
Cheers!
-klm.
- Original Message -
From: "Shao, Chunning" <[EMAIL PROTECTED]>
To: "Shao, Chunning" <[EMAIL PROTECTED]>; "Aaron J. Mackey"
<[EMAIL P
Greets Folks,
Quick question here... Is there a command I can use to select the most
recent files inserted into a MySQL table?
Thanks,
=)
Will
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
Hi, everyone,
In DBI, is there any way we can do something like
"alter session set current_schema=user"?
I need to do it but it does not seem to work.
Thanks
Sorry, i forgot to change the subject in the first message.
Sorry
Hi, everyone,
In DBI, is there any way we can do something like
"alter session set current_schema=user"?
I need to do it but it does not seem to work.
Thanks
The newest SQL::Statment is available at:
http://www.cpan.org/modules/by-authors/id/J/JZ/JZUCKER/
Users of DBD::CSV, DBD::AnyData, DBD::Excel and other modules
subclassing SQL::Statement are recommended to upgrade. A comparison of
this version and earlier XS versions is available at:
ht
I am trying to get output of a table from a stored procedure. The select statement
works with fetchall_arrayref, but this is a little different.
The perl code that I have is this:
#!/usr/local/bin/perl
use DBI;
require "/proj/dsa/www/shared/perl/config.ph";
$dbh = DBI->connect($main::DB_DATASOU
Paul/Tom,
I've run it a number of times now. I got better results with DBD::ODBC 0.38
(well, actually, the unreleased .39), but I didn't find anything obvious in
the trace other than the memory corruption.
Jeff
>
> Hi Tom,
>
> I had exactly the same problem with DB2 on two workstations.
> NT4
Hello all, perhaps someone has come across this problem and can help me out.
I'm a newbie to the Win32 environment and it's killing me..
I'm on Win32 platform, using Perl, using the Informix Client SDK 2.5
(driver INFORMIX 3.32 32 BIT). It's installed properly as I can use their
"logon and ping"
Nadim, in both this and a previous posts, has asked the very valid
question of "Why bother? We already have DBI for this." I'd like to try
to address his point.
On Fri, 1 Mar 2002, Nadim Khemir wrote:
> 2/ If someone wants to write Inline::InternetExplorer, I don't care, if that
> someone want
For my particular beef, the -8 flag works when compiling the DBD module
as suggested below.
Original Message
Subject: RE: Whitespace being truncated with Oracle
Date: Fri, 1 Mar 2002 12:18:34 +0100
From: "Jan Matejka" <[EMAIL PROTECTED]>
To: "'Jeff Hunter'" <[EMAIL PROTECTED]>
Hey, why don't you just upgrade to the latest DBI.
ppm install http://www.xmlproj.com/PPM/DBI-1_21.ppd
I believe the latest version that will work is the one version below, since
there were changes implemented in DBI 1.21 that were also then accompanied
by changes in DBD::ODBC (if I recall corre
Hi All,
I tried to install DBD::ODBC driver , version .38 on
Solaris. We have DBI version 1.20 installed on Perl
v5.6.1
We got the message that DBD:ODBC v.38 requires DBI
1.21 or greater.
Please let me know which is the latest version of
DBD::ODBC which will work on DBI 1.2
TIA
Arvind L
___
There has been quite a bit of followup to my first posted ramblings; I've
recieved lots of ideas, most of them very good. Fundamentally, though,
there's the idea that this isn't really an "Inline" package, as in
"(pre)compile this bit of native language in some other language-space and
then make
On Fri, Mar 01, 2002 at 12:12:28PM +0100, Peter J. Holzer wrote:
> On 2002-02-28 15:58:31 -0800, Rob Bloodgood wrote:
> > > Now of course Oracle and some other vendors I don't care to mention
> > > love straying from the path and taking their own approach, but then
> > > call themselves SQL ## com
On 2002-02-28 15:58:31 -0800, Rob Bloodgood wrote:
> > Now of course Oracle and some other vendors I don't care to mention
> > love straying from the path and taking their own approach, but then
> > call themselves SQL ## compliant. Oracle has a major trailing space
> > problem that was discussed
Assumning you have SSI setup and working, you simply write CGI scripts that
query the database and create HTML data islands. These are then included in
your documents using SSI directives.
In the HTML document in which you wish to embed the data, include an SSI
directive pointing to the CGI scri
Hi Tom,
I had exactly the same problem with DB2 on two workstations.
NT4, sp5, ActivePerl 5.6.1-628, DBI 1.20, DBD-DB2 0.75 and
W2K, sp2, ActivePerl 5.6.1-631, DBI 1.201, DBD-DB2 0.75
Collecting data from 3 databases (DB2 v2.1.2) OS2 Warp Server using DB2
client 5.2
to combine the data into a RS
>Date: Fri, 01 Mar 2002 09:44:35 +
>To: "Marlon Rensch" <[EMAIL PROTECTED]>
>From: Mark Thornber <[EMAIL PROTECTED]>
>Subject: Re: problems installing perl dbi on solaris8
>
>Marlon,
>
>I think it is because the makefile is picking up /usr/ccs/bin/as rather
>than the gnu version. May be you
> 1. Don't see a clean way to do the usual prepare(), while(fetch())
> looping you'd normally do with DBI; Inline::SQL functions will always
> return all of the results (potentially very large sets).
How about using a callback function - all function prototypes could have an
implict 'callback' p
On Thu, Feb 28, 2002 at 10:14:08PM -0800, Dean Arnold wrote:
> Just stumbled on this in c.l.p.modules, thought it deserves to be
> bounced around here...IMHO, this would be *very* gnarly!
Bounced around on dbi-users, that is, not dbi-dev.
Also, I've CC'd the author.
Tim.
> - Original Messag
On 2002-02-28 18:32:09 -0700, Sterin, Ilya wrote:
> Peter, I understand, but silly or not silly, if it's the standard, I'd
> rather have it followed than to fullfill someones request based on their
> current need. I totally agree and you have a good argument, but the
> standard is the standard, a
On Thu, Feb 28, 2002 at 11:11:10PM +0100, Peter J. Holzer wrote:
>
> SQL> insert into foo(t) values('test ');
>
> At least sqlplus doesn't remove spaces on insert, and a select returns
> them from both sqlplus and perl.
That's not a fair test. sqlplus isn't involved as there's no parameter
bi
Hello,
i've been trying for a couple of weeks now to install the Perl DBI on my Sparc box (
i'm running solaris8) but i can't get pass the "make" command. Below are the error
messages i'm getting. Could you please tell why this is happening?
# perl5.6.1 Makefile.PL
*** Note:
The optional P
on Oracle 7.3.4.0.1:
SQL> @varchar2_test.sql
Table created.
PL/SQL procedure successfully completed.
1 row created.
Commit complete.
COL1
--
"123 "
Michael A Chase wrote:
>
> It's hard to see what the standard would be. Tim changed the behavior
> somewhen around
24 matches
Mail list logo