Re: 2 cursors? at the same time

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 question

Re: 2 cursors? at the same time

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: >List-Help: >List-Unsubscribe:

2 cursors? at the same time

IABLES # my $row; my $length; my $pageLen = 300; my $page2plusNum; # number of ticket with more than 2 pages ### # Globals ### # or $ROOTDIR = pwd my $ROOTDIR = '/yoda/home/dba/STA/cnsn_ops_log/UPDATE_20041103/2005

RE: Problem with connecting to an Oracle database using Perl

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 als

DBD::Proxy breaking die within eval strangeness

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 trans

RE: Double quotes in select statement throw an error

> 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 connecti

RE: Problem with connecting to an Oracle database using Perl

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 [mailto:[

RE: Double quotes in select statement throw an error

> > 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-select

RE: Double quotes in select statement throw an error

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, paddin

RE: Double quotes in select statement throw an error

> 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

Re: Problem with connecting to an Oracle database using Perl

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 tit

Re: Problem with connecting to an Oracle database using Perl

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 w

Another drawing tool: SQLFairy (sic) aka SQL::Translator

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

Re: Double quotes in select statement throw an error

On Tue, Jan 18, 2005 at 11:22:58PM -0500, Moosmann, James wrote: > Perl DBI thinks any double quoted string must be a column > or table name ( [ and ] are preferred, but double quotes are still > acceptable). Not true. Neither the DBI nor the driver (generally) parse the SQL. The DBI gives it to t