Another quick thing to check is: did you rebuild DBD::Oracle since upgrading?
Just checking...
Jeff
>
> On Jan 24, Spiraquis Alexis (SFO) scribed:
>
> > Hello
> >
> > I have on my server 5.005_03 built for sun4-solaris installed with
> > DBI(v1.13). I was previously accesing a Oracle 7.3.4
>
[Tue Jan 25 04:53:23 2005] [error] [client 127.0.0.1] DBD::Oracle::db
prepare failed: ORA-00900: invalid SQL statement (DBD: error possibly
near <*> indicator at char 1 in '<*>DESC iwdeltracker') at C:\\Program
Files\\Apache Group\\Apache2\\cgi-bin\
I think "DESC" is not an SQL statement.
It is an
> From: "Jenda Krynicky" <[EMAIL PROTECTED]>
> Date: 2005/01/24 Mon PM 06:02:03 CST
> COUNT()
> doesn't count the rows in which the first_column is null.
> If you want the count of rows, use COUNT(*), if you want the count of
> Foos use Count(Foo).
Hard to argue with that, indeed it is. My
DESCribe is a SQLPlus command (which Toad is emulating), not valid SQL.
There are other DBI functions to do the same thing that DESC does. See
table_info and column_info in the DBI docs.
HTH,
Dave
On Jan 25, [EMAIL PROTECTED] scribed:
>
> Error Message is
>
>
>
> [Tue Jan 25 04:53:23 2005] [err
Error Message is
[Tue Jan 25 04:53:23 2005] [error] [client 127.0.0.1] DBD::Oracle::db
prepare failed: ORA-00900: invalid SQL statement (DBD: error possibly
near <*> indicator at char 1 in '<*>DESC iwdeltracker') at C:\\Program
Files\\Apache Group\\Apache2\\cgi-bin\
As you can u see I am t
From: amonotod <[EMAIL PROTECTED]>
> > From: amonotod <[EMAIL PROTECTED]>
> > > From: Hernan Arredondo <[EMAIL PROTECTED]>
> > > Date: 2005/01/24 Mon PM 12:41:56 CST
>
> > FROM THE DOCS!
> >
> > One alternative method to get a row count for a SELECT is to
> > execute a ``SELECT COUNT(*) FROM
On Tue, 25 Jan 2005 08:43:18 +1100, Ron Savage <[EMAIL PROTECTED]> wrote:
> On Mon, 24 Jan 2005 12:50:38 -0800, Darren Duncan wrote:
>
> Hi Folks
>
> > If you go to http://www.nntp.perl.org/group/ then you will get a
>
> This is what I have on file, but I did not check them recently:
>
> 1 http
Any traction on this?
On Fri, 2005-01-14 at 10:17, Jeff Zucker wrote:
> Jeff Benton wrote:
>
> >Sorry if I posted this twice - I did not see my first post go through.
> >
> >I am trying to do a join across to csv files but have been unsuccessful
> >up to this point.
> >
> >
> ...
>
> >I get th
> From: amonotod <[EMAIL PROTECTED]>
> Date: 2005/01/24 Mon PM 02:03:18 CST
> > From: Hernan Arredondo <[EMAIL PROTECTED]>
> > Date: 2005/01/24 Mon PM 12:41:56 CST
> > anyone knows other easy method ?
> FROM THE DOCS!
>
> One alternative method to get a row count for a SELECT is to
> exec
On Mon, 24 Jan 2005 12:50:38 -0800, Darren Duncan wrote:
Hi Folks
> If you go to http://www.nntp.perl.org/group/ then you will get a
This is what I have on file, but I did not check them recently:
1 http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/
2 http://www.xray.mpe.mpg.de/mailing-li
> From: David Goodman <[EMAIL PROTECTED]>
> Date: 2005/01/24 Mon PM 02:40:21 CST
> Is there a searchable archive for the DBI mailing
> list?
There's always Google
http://www.google.com/search?q=site%3Anntp.perl.org+perl.dbi.users+%22your+search+term+here%22
Replace "your+search+term+here" w
At 12:40 PM -0800 1/24/05, David Goodman wrote:
Is there a searchable archive for the DBI mailing
list?
regards,
David
If you go to http://www.nntp.perl.org/group/ then you will get a list
of archives for all the mailing lists that are [at]per.org or
[at]cpan.org . Click on the perl.dbi.users li
Is there a searchable archive for the DBI mailing
list?
regards,
David
> From: Hernan Arredondo <[EMAIL PROTECTED]>
> Date: 2005/01/24 Mon PM 12:41:56 CST
> of rows affected by a select statement, use the "$var = $st->rows" but
> it no works in select statements, the other way is making a while
> statement to get the result in an array, but I think is a easy way to
>
What happens if you try the statement in sqlplus user/[EMAIL PROTECTED] This
doesn't look like a connectivity issue, except where user may not own
the table you are selecting from, i.e. try "select ... from owner.table"
if you are connecting as 'user' rather than 'owner'. Of course, 'user'
needs
Hello
I have on my server 5.005_03 built for sun4-solaris installed with
DBI(v1.13). I was previously accesing a Oracle 7.3.4 Database without
problems. Now I tried to access the same DB but migrated to 8.1.7 and I get
the following error:
DBD::Oracle::db prepare failed: ORA-00942: table or view d
Hi all,
I have a question:
I use DBI and DBD::Oracle with no prob. but I need to retur the number
of rows affected by a select statement, use the "$var = $st->rows" but
it no works in select statements, the other way is making a while
statement to get the result in an array, but I think is a easy
Phillip Hellewell wrote:
> Hello,
> I'm using DBI and DBD:ODBC in my perl script. I'm also using
> DBI::Const::GetInfoType. I was trying to get the database name using
> $dbh->get_info( $GetInfoType{SQL_DATABASE_NAME} ), and it returned 0,
> but $dbh->get_info( 16 ) worked! So I looked in
"Jeff Zucker" <[EMAIL PROTECTED]> píse v diskusním príspevku
news:[EMAIL PROTECTED]
> RH wrote:
>
>>Hi,
>>I have an app which connects via DBI:DBD:CSV to a flat file.
>>When I include pragma use encoding,
> Ah, ok I found it. This patch to DBD::File fixes it.
>
> 533c533
> < sprintf('(?:%s|%
I have been experiencing some problems with the following configuration:
Solaris 5.7 on a Sun Ultra-250, running Apache 2.0.48, mod_perl 1.9913
(built as DSO)
I'm using the following perl modules:
Perl 5.8.0
DBI 1.46
DBD::ODBC 1.13
Apache::DBI 0.94
The RDBMS is Mimer 8.2.5G (www.mimer.com), con
20 matches
Mail list logo
