Hi Folks
http://savage.net.au/Ron/html/drawing-tools.html
Thanx to Remo Sanges.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/01/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
Hi Charles,
Try setting your environment variables in a BEGIN block, like this:
#!/usr/bin/perl -w
use strict;
BEGIN {
$ENV{'NLS_LANG} = 'american';
$ENV{ORACLE_HOME} = 'D:\Oracle\ora92';
}
### the rest of your code goes here ###
I haven't done Perl/DBI/Oracle in quite a while, but that's
It's probably worth pointing out here that the use of the BEGIN block
*IS* described in the DBD::Oracle perldocs - as the perldocs are
included when you install any module, after you install DBD::Oracle you
can do
perldoc DBD::Oracle
to read the excellent perldocs. Look for the paragraphs
Lee,
The select statement is very valid and so is:
SELECT 'Hello World!' as 'My first SQL Statement'
-or-
SELECT answer = 2+3
Really, try it.
Anyway... I was sent the correct answer and was very
surprised in that the syntax is indeed valid on some servers,
however the ANSI
Thank you everyone who responded and to Tim and Jeff:
The reason the server generates an error is because there are 2 flags which
can be set when you create the DSN:
Use ANSI quoted identifiers
Use ANSI null, padding and warning
And they were both selected.
De-selecting Use ANSI null,
Thank you everyone who responded and to Tim and Jeff:
The reason the server generates an error is because there are
2 flags which can be set when you create the DSN:
Use ANSI quoted identifiers
Use ANSI null, padding and warning
And they were both selected.
De-selecting Use
Your environment is not correct, specifically ORACLE_HOME and maybe the NLS
vars. I would look at the DBD::Oracle docs. They have information on env vars
and how to connect.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Charles Lawrence
From: Moosmann, James [EMAIL PROTECTED]
Date: 2005/01/19 Wed AM 08:24:12 CST
Does anyone know how to check/set this attribute using DBI so I don't have
to instruct a user on changing his DSN? ( I don't see this option mentioned
in DBD::ODBC )
Might I suggest using DSN-less connections, so
Hello,
I'm having a very strange problem with DBD::Proxy and have ended
up with brain meltdown - so now its your turn ;-)
Basically, if I use DBD::Proxy to connect to a database (just doing
a 'use DBD::Proxy' isn't enough), then localise $dbh-{AutoCommit}
within an eval (to locally turn on
Her's a snippet that works.
BEGIN {
if (($^O eq 'MSWin32') or ($^O =~ /cygwin/i)) {
# $ENV{ORACLE_HOME} = q{C:/Oracle/Ora81}; # But Oracle::DBD will find it
from the Windows registry
} else {
$ENV{ORACLE_HOME} = q{/solarisdirectory/app/oracle/product/8.1.7};
}
# Following string is
###
# or $ROOTDIR = pwd
my $ROOTDIR = '/yoda/home/dba/STA/cnsn_ops_log/UPDATE_20041103/20050119';
my $sep='@';
my $actionCount = 0;# actionid counter which is actually almost ticketid
# as for old data we are assuming
Hi all,
I found solution myself reading information from the google group.
I should autocomit off. I did it and works.
Nina
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-Post: mailto:dbi-users@perl.org
List-Help: mailto:[EMAIL PROTECTED]
List-Unsubscribe: mailto:[EMAIL PROTECTED]
On 01/19/2005 05:01 PM, Nina Markova said:
I found solution myself reading information from the google group. I
should autocomit off. I did it and works.
Thank you for the followup with the solution you found. It may be
useful to someone else later.
--
Mac :})
** I usually forward private
13 matches
Mail list logo