a DML
statement?
Regards
Dan Horne
OK, understood
Thanks
Dan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 1 November 2005 9:51 a.m.
To: Dan Horne
Cc: dbi-users@perl.org
Subject: Re: connect_cached and transactions
On Tue, Nov 01, 2005 at 08:57:49AM +1300, Dan Horne wrote:
Hi
the later versions of SQL*Net, but it's something that you
could look at
Dan
Henri Asseily [EMAIL PROTECTED]
23/11/2004 08:11
To: Bob Showalter [EMAIL PROTECTED]
cc: 'Kevin Bass' [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], (bcc: Dan Horne/IT/AKLWHG/WHNZ
if you think it's a DBD::ODBC issue, why not use DBD::Sybase instead?
Dan
Moosmann, James [EMAIL PROTECTED]
19/10/2004 16:17
To:'[EMAIL PROTECTED]'
[EMAIL PROTECTED]
cc:'[EMAIL PROTECTED]' [EMAIL PROTECTED], (bcc: Dan
Horne/IT/AKLWHG
James
if you think it's a DBD::ODBC issue, why not use DBD::Sybase instead?
Dan
Moosmann, James [EMAIL PROTECTED]
19/10/2004 16:17
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED], (bcc: Dan
Horne/IT/AKLWHG/WHNZ)
Subject
for the transaction id
CGI::Session should help you out here for storing either your session
object or your transaction id.
Dan
Luca Ferrari [EMAIL PROTECTED]
07/09/2004 03:55
To: [EMAIL PROTECTED]
cc: (bcc: Dan Horne/IT/AKLWHG/WHNZ)
Subject:[SPAM
[EMAIL PROTECTED]
27/08/2004 07:25
To: [EMAIL PROTECTED]
cc: (bcc: Dan Horne/IT/AKLWHG/WHNZ)
Subject:DBI insert records
Hi list,
Datetime column is a datatype date, when I insert records using the
following code I am getting 'ORA-01858: a non-numeric
According to metalink.oracle.com, there is no 8i client support for MAc OS X
(as at Jan 2002)
Dan
-Original Message-
From: Chuck Tomasi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 8:33 AM
To: '[EMAIL PROTECTED]'
Subject: Oracle 8i client for Mac OS X
Does anyone know
How about using to_char on the date column in the select, but still order by
the date column itself? e.g.
$dbh-prepare(SELECT TO_DATE(when, 'FORMAT_STRING') FROM mytable ORDER BY
when);
Dan
-Original Message-
From: Richard Phillips [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04,
$ado_conn-{Provider}, \t,$ado_conn-{Version}, \n;
my $tia = $dbh-type_info(SQL_VARCHAR);
print SQL_VARCHAR type: , $tia-{TYPE_NAME}, \n;
$dbh-disconnect if $dbh;
exit;
__END__
On Thu, Nov 29, 2001 at 05:59:11PM +1300, Dan Horne wrote:
I know the definitions, syntax are in the doco, but can someone
Hi
I know the definitions, syntax are in the doco, but can someone send me some
concrete examples of type_info being used?
Thanks
Dan
Can someone give me some examples of high-volume, high-profile sites using
mod_perl and dbi?
Thanks
Dan
Try DBD::CSV. You can select from the text file using SQL
Dan
-Original Message-
From: Scott Taylor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 10:14 AM
To: [EMAIL PROTECTED]
Subject: CSV-SQL convertion
Hello,
Does anyone have a routine to convert from a csv file to
Hi
I have a batch script that performs the following tasks
prepare insert statement for oracle
loop through files in a directory
read each line from the current file using dbd-csv
insert into oracle using dbd-oracle
end loop
This runs fine on Windows 2000, but when I try on NT, after
Hi All
I'm currently writing a db application based on Oracle with Perl batch
processing, and am intending to implement a GUI front end. Perl/Tk looks
like a possible option. I'm reasonably new to Perl but feel confident enough
in it to create a functional app, even if the code is not written in
ORA 3121 means that your interface interface driver cannot be found. Does
SQL*Plus work from the MS-DOS/command window? If not, it could be that the
ORACLE_HOME is not set correctly
Dan
-Original Message-
From: Jose Aguayo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 5:38
To install Oracle 8.1.7 on RH 7.1, you must first install the RH 6.2
compatibility packages (compat-egcs, compat-glibc and compat-libs) from the
7.1 CDs. Enter the following before running the Oracle installer:
export LD_ASSUME_KERNEL=2.2.5
. /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh
too. I don't know if there are others.
Dan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 9:31 PM
To: Dan Horne
Cc: [EMAIL PROTECTED]
Subject: Re: Autocomit and oracle packages
On Wed, Sep 26, 2001 at 03:12:53PM +1200, Dan Horne wrote:
Hi
You don't need to install everything to use Oracle Client for Linux.
Unfortunately, unlike Windows editions, the Client installation comes as
part of the Enterprise Software package. When you launch the installer, you
are asked whether you want to perform a client or Enterprise install. Choose
Sorry for being OT, but can someone direct me to a users froup for
discussing Net::FTP issues?
Thanks
Dan
Hi all
I don't know if this has been discussed on this list before, but I just
thought I'd mention it as it took me a while to figure out why my code
wasn't working. If you call an Oracle supplied package that requires a
commit after being called (such as dbms_alert), Autocommit will not take
Andrey
the ora-1 error normally occurs when there is a syntax error in your
connect string. Try using the alias in your tnsnames.ora file instead
my $dbh = DBI-connect(dbi:Oracle:$db_sid, $db_user, $dp_pass)
where $db_sid is the alias name. When you mentioned that SQL*plus can
connect,
Try userenv('SESSIONID') to discover your own session's audsid
SQL select userenv('SESSIONID') from dual;
USERENV('SESSIONID')
13591
SQL select sid,serial#,audsid,program from v$session where audsid=13591;
SIDSERIAL# AUDSID PROGRAM
23 matches
Mail list logo