-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jan 09, 2002 at 02:53:11PM -0500, Stan Brown wrote:
> What I have in mind is doing a prepare on this statement, and checking the
> return code. Does this sound like it will catch invalis statements? If so,
> how do I do this safetly without ri
A less "Oracle" only solution is to query the table/view in question
using predicate of 1 = 2
prepare and execute a statement like this:
select * from view/table where 1 = 2
Now, if the view is doing A LOT of work behind the scenes, performance
could be questionable.
In a future releas
On Wed, 9 Jan 2002 15:03:56 -0600, Moritz von Schweinitz wrote:
>it seemed as if b-trieve was somehow capable of storing data internally
>as trees or something like that, but i haven't heard anything about it
>for a while, so i guess it got a bit obsolete...
Then you should take a look at Berkel
More OT but I have to chime in ... I also used B-Trieve
in the 80's. Not much as a true developer -- it was used
in a system I had to maintain for a while. There was one
function call, so I guess you can't get much simpler than
that.
Here's where I got a shock that I never verified was true:
A little OT, but it is actually being used in a production software
package called Teleform from Cardiff software. Teleform is an OCR
program which you use to create forms, OCR them from fax or scan, and
then store the information in a database. BTrieve is used to store the
forms themselves, whil
On Wed, Jan 09, 2002 at 03:03:56PM -0600, Moritz von Schweinitz wrote:
> my two cents:
> some professor of mine who was in love with b-trees kept on talking
> about b-trieve, and how terrrible (?) it was that they now belong to
> pervasive or something like that.
As if it's fate would be far nob
I did B-trieve a billion years ago, well in the late 70s anyhow. Remember
about as much about it as mainframe PL/1, Fortran and Be-stop (not to be
confused with B-trieve!). Still trying to reclaim memory cells where 20
years of COBOL was stored. Things like Corba, Powerbuilder, JSP, Sybase
EASe
Summary: Read the Changes file with each release.
Tim.
p.s. I know I need to also update the "Recent Changes" sectin in
the pod docs in future.
On Wed, Jan 09, 2002 at 12:12:37PM -0500, Rozengurtel, Daniel wrote:
> Hi All.
>
> Please people can you respond to my previous posting? Its a prod p
On Tuesday, January 8, 2002, at 09:27 PM, John Tankersley wrote:
> Hello,
>
> My name is John Tankersley. I am seeking some help with the perl
> modules. I hope I understand the dbi modules. Please correct me if I am
> wrong.I am building databases using mysql.
Have you considered postgresql? I
my two cents:
some professor of mine who was in love with b-trees kept on talking
about b-trieve, and how terrrible (?) it was that they now belong to
pervasive or something like that.
it seemed as if b-trieve was somehow capable of storing data internally
as trees or something like that, but i h
Sorry to not have answered your problem. Just trying to help.
-Jim
Rainer Brandt wrote:
> Hi Jim,
>
> the subject (and the body) of the message was about "use DBI and perlcc".
> It was not how to specify a dsn.
>
> You said:
> > $dsn= 'dbi:ADO:MyDatabase';
> > $dbh = DBI->connect("$dsn", "$
Stan,
I don't completely understand your application, but here is the query I'd
use.
SELECT COUNT(*) FROM ALL_OBJECTS O, ALL_TAB_COLUMNS C
WHERE
O.OWNER = 'FOO'
AND OBJECT_NAME = 'BAR'
AND COLUMN_NAME IN ('BLAH', 'RAH')
AND OBJECT_TYPE IN ('TABLE', 'VIEW')
AND O.OWNER = C.OWNER
AND TABLE_NAME =
On Wed, 9 Jan 2002, Chris Denman wrote:
> Date: Wed, 9 Jan 2002 20:05:33 -
> From: Chris Denman <[EMAIL PROTECTED]>
> To: Alex Pilosov <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: What is Betrive?
>
> Aha!
I think that it evolved into something else, p...sql
Novel owned them at one
At 02:51 PM 01/09/2002, you wrote:
>Has anyone heard of Betrive?
>
>I have had a look on Google, but there's not much on it.
It's spelled Btrieve. Btrieve is now Pervasive SQL, if I recall
correctly. Try http://www.pervasive.com
-Mike
Aha!
An agency asked me if I knew anything about Betrive, he obviosly wrote it
down as he heard it!
Thanks ever so much - a bit of research is now in order
Chris
- Original Message -
From: "Alex Pilosov" <[EMAIL PROTECTED]>
To: "Chris Denman" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTE
Its b-trieve, that's why ;)
On Wed, 9 Jan 2002, Chris Denman wrote:
> Has anyone heard of Betrive?
>
> I have had a look on Google, but there's not much on it.
>
> Chris
>
>
>
>
Has anyone heard of Betrive?
I have had a look on Google, but there's not much on it.
Chris
I'm modifying a script that connects to Oracle to collect data. Previously
it could only get data from a table, and now I'm adding ghe ability to get
data from a view.
Because of the environment it runs in, and the fact that it's configuration
table driven, on the fly. I need a LOT of error check
This is off-topic for dbi-dev, so I am forwarding to dbi-users. If you
haven't subscribed to it, do so at this time, as all responses will go
there.
Ilya
See Jose's note below.
-Original Message-
From: Jose Blanco
To: [EMAIL PROTECTED]
Sent: 1/9/02 12:30 PM
Subject: Using Sprite
I am
>> I am getting core dumps for base.t and general.t during make test, except
>> when I build the makefile with the -p option.
>So using -b does the same?
Actually, my notes say I coredump with the -b option as well.
>> Then I get 'symbol not found: ecvt'.
>You could try following the "symb
I just managed to successfully do this myself not long ago. I'll send you
more info in a bit.
-Original Message-
From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: Stored Procedure with Oraperl
Hello,
Is there som
Hello,
Is there somebody who can tell me how I can execute
a Stored Procedure with Oraperl ?
I know that is possible to do that with DBI but
I have a constraint to keep Oraperl that I'm using now.
Thanks in advance,
José.
DISCLAIMER
"This e-mail and any attachment thereto may cont
I guess you took the time to actually see the code. Good response. See if
you can run it with those fixes before trying my suggestions.
Ilya
-Original Message-
From: David M. Lloyd
To: Rozengurtel, Daniel
Cc: '[EMAIL PROTECTED]'
Sent: 1/9/02 10:19 AM
Subject: Re: FW: DBI Problem
Looks
Upgrade your DBI. Looks like you are using an older version. This bug was
fixed I believe. You should be able to run fine without the -w switch if
you can't upgrade.
Ilya
-Original Message-
From: Rozengurtel, Daniel
To: '[EMAIL PROTECTED]'
Sent: 1/9/02 10:12 AM
Subject: FW: DBI Proble
Looks like you are doing at least two things wrong. (1) you are using
selectall_hashref wrong; see this doc snippet:
"selectall_hashref" NEW
$hash_ref = $dbh->selectall_hashref($statement, $key_field);
$hash_ref = $dbh->selectall_hashref($statement, $key_field, \%attr)
Hi All.
Please people can you respond to my previous posting? Its a prod problem and
i would really like to get going.
Thanx a lot.
Danny
> -Original Message-
> From: Rozengurtel, Daniel
> Sent: Wednesday, January 09, 2002 9:52 AM
> To: '[EMAIL PROTECTED]'
> Cc: Rueth, Loretta F.
As of Oracle 8.0.5, the DESCRIBE command was not part of the server code.
It was only supported by tools such as sqlplus. I have not tried newer
versions of Oracle, but I notice that DESCRIBE is not in the SQL Reference
for 9i. Here is a query that should work for you:
SELECT COLUMN_NAME, DATA_
Applied. Thanks!
Tim.
On Wed, Jan 09, 2002 at 03:53:33PM +0100, Kay Röpke wrote:
> Hi!
>
> Until recently we have used DBI-1.15 in our product. After trying to
> upgrade to DBI-1.20 (or anything after 1.15) our SQL select statements
> broke in a curious way:
>
> In a lot of places we have to
I think I got it. I had the Oracle 7 libs installed, and therefore
DBD::Oracle wasn't failing, while the one compiled with OCI 8 was. Sorry, I
didn't even know that I had those libs on my machine. Must of installed a
while back.
Ilya
-Original Message-
From: Ballantyne.William
To: Ste
Hi!
Until recently we have used DBI-1.15 in our product. After trying to
upgrade to DBI-1.20 (or anything after 1.15) our SQL select statements
broke in a curious way:
In a lot of places we have to rely (for performance reasons) for
something like this to succeed:
select *, trim(leading '*'
Hello friends,
I have a problem with DBI.pm module running on Sun5.8. While using
selectall_hashref i get this strange error. I am 100% sure the table to
select from does exist. And that the same statement works on our dev machine
(which is Sun5.6) We also descovered that there is a diference in
On Wed, Jan 09, 2002 at 02:46:38PM +0100, Rainer Brandt wrote:
>
> Tim Bunce writes:
> > On Tue, Jan 08, 2002 at 07:19:09PM +0100, Rainer Brandt wrote:
> [...]
> > > You said:
> > > "when i try execute compiled binary file i'v got
> > >"'cannot locate method "connect" via class DBI'."
> >
Tim Bunce writes:
> On Tue, Jan 08, 2002 at 07:19:09PM +0100, Rainer Brandt wrote:
[...]
> > You said:
> > "when i try execute compiled binary file i'v got
> >"'cannot locate method "connect" via class DBI'."
>
> That message is talking about the "class DBI", so the DBI itself
> has not be
> use strict;
> sub Main {
> $dbh = DBI->connect('dbi:Oracle:', 'john/wayne@western','');
> }
> So where is the problem?
When you use "use strict" you need to declare your variables or give
them full names:
a) leave out "use strict" (not recommended)
b) my $dbh = DBI->...
c) $main::dbh = DBI->
Odd, the DBD::Oracle package from ActiveState did fail in my case. I
installed the binaries from them on a clean system (w2kas), no install
warnings. Everything went to the proper places. The Oracle.dll file was in
the correct place. Try to use the DBD::Oracle and it gives the error.
Install c
On Wed, Jan 09, 2002 at 12:49:33PM +0100, [EMAIL PROTECTED] wrote:
> I did following:
>
> perl Makefile.PL -nob --> same result
> perl Makefile.PL -c--> same result
> perl Makefile.PL -n LIBCLNTSH --> same result
> perl Makefile.PL -p--> same result
>
> only res
Hi John,
> I have SuSE 7.3 installed on my system. I am using mysql to create
> database tables. I was using db2 for linux but they want alot of money
> for their product so I am going to use mysql instead. Is my
> understanding correct that you use the dbi interface to link perl
> modules to my
Hillow,
i have a simple question: can I use SQL command DESCRIBE instead of SELECT in
this case:
...connect..
my $oraSQL = qq/SELECT * FROM TABLENAME /;
...do something..
...disconnect..
Or maybe there is another way to get table column names?
Hope You undestood my problem..:)
Mario.
I did following:
perl Makefile.PL -nob --> same result
perl Makefile.PL -c--> same result
perl Makefile.PL -n LIBCLNTSH --> same result
perl Makefile.PL -p--> same result
only result of "perl Makefile.PL -l" did vary:
"make" failed with:
"*** Error code 1
make
Hello,
My name is John Tankersley. I am seeking some help with the perl
modules. I hope I understand the dbi modules. Please correct me if I am
wrong.I am building databases using mysql.
I have SuSE 7.3 installed on my system. I am using mysql to create
database tables. I was using db2 for linux
Hi Sal,
> > link -out:..\..\blib\arch\auto\Tk\X\X.dll -dll -nologo
-nodefaultlib
> -re
> lease -libpath:"C:\perl\lib\CORE" -machine:x86 X.obj
> C:\perl\lib\CORE\perl56
> .lib oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
> comdlg32.lib a
> dvapi32.lib shell32.lib ole
Now follow the advice in README.help about trying various combinations of
options (-b / -p etc) to Makefile.PL.
Tim.
On Wed, Jan 09, 2002 at 11:34:34AM +0100, [EMAIL PROTECTED] wrote:
> > Your DBD::Oracle and DBI should always be built with the
> > same compiler as built the perl you'll be using
On Tue, Jan 08, 2002 at 07:19:09PM +0100, Rainer Brandt wrote:
>
> Hello,
>
> you asked about a problem with your Perl/DBI program when compiled
> by perlcc. Unfortunately I don't know a solution, but I believe I
> know a bit more about the cause.
>
> You said:
> "when i try execute compiled
Bart,
you said:
> perl2exe has similar problems. The solution there is to add the line
> (for this particular example):
>
> require DBD::ADO;
>
> or even:
>
> require DBD::ADO if 0;
That's what I tried (with DBD::Sybase). It was a year ago, with Perl
5.0 patchlevel 5 subversion 3
> Your DBD::Oracle and DBI should always be built with the
> same compiler as built the perl you'll be using it with. All else
> is doomed to heartache.
>
> Build yourself a new perl and start over.
>
> Tim.
okay.. did so:
installed perl5.6.1 (and before that I installed gcc2.95.3 - binary fro
On Tue, 08 Jan 2002 20:53:19 -0800, Jim Clark wrote:
>I use the following code in my DBI scripts:
>
>$dsn= 'dbi:ADO:MyDatabase';
>$dbh = DBI->connect("$dsn", "$user", "$pass") or die "Database connection not
>made: $DBI::errstr";
>
>Thus, the DSN string specifies the driver to use without ext
Hello,
I'am new to Perl and DBI so excuse me if the question is (so) stupid.
I installed the DBI and the DBD::Oracle modules. Installation and tests
worked well.
I try a little script to connect to database and it failed.
Here is the few lines:
use DBI;
use strict;
Main();
sub Main {
$dbh =
47 matches
Mail list logo
