The way Oracle handles character sets is to map from the client's
set to the set defined in the DB. For example, if you create a
database as ISO-8859, but your client is USASCII, then when the
client queries the DB, Oracle will map from the ISO set to ASCII.
Since ISO is a superset of ASCII, th
I have a problem like this:
We have got data in Excel sheet from client.It contains 6 cells and
nearly 5000 rows.we r importing that data into a table by using VB.The
data will be in several languages like English,Deutch,French,German etc.
Except English all other languages contains some special
This isn't much of a DBI answer, but in Oracle 8.1.6.0 RedHat 6.2,
Killing the shadow process of a local sqlplus non-sqlnet connection
results in ora-12571: TNS:packet writer failure. I suppose the same
would happen with a dbi program, but I haven't read enough dbi
documentation to know how to
> -Original Message-
> From: Ali Zaidi [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 8:51 PM
> To: [EMAIL PROTECTED]
> Subject: statement resulting in a core dump
>
>
> Hi:
> I am trying to execute a piece of code that works in one
> variation and dumps core in another.
> T
Hi:
I am trying to execute a piece of code that works in one
variation and dumps core in another.
The one which works is
my ($stmt);
eval {
$stmt=$db->prepare_cached ("update job_queue set
status_flag='JDP' where sid= $sid ");
$stmt->execute;
$stmt->finish;
};
if ($
Just off the top of my head, I'd run just one select with an ORDER BY clause
that puts the returned rows in the same order as the array. Then I'd run
through the two sets to see what matches.
This is untested, but it should scale fairly well. If you have more then
50-100K elements in @compare_a
- Original Message -
From: "Dirk Gomez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 15:34
Subject: multiple updates of CLOBs within a loop
> Has someone an example for this:
>
> (tcl-style code, I'm deeply stuck in TCL at the moment, I'm sorry ;)
>
> set sq
Why are you making the %compare hash?
Why not,
foreach my $id (@compare_array) { print "Found\n" if exists $seen{$id}; }
or another way would be,
my $ar = $dbh->selectall_arrayref('select userid from subscriptions');
my %seen;
map { $seen{$_->[0]}++ } @$ar;
Remember to w
Why not this:
my $sth = $dbh->prepare('SELECT userid FROM subscriptions');
my %seen;
while (my ($id) = $sth->fetchrow) {
$seen{$id}++;
}
my %compare = map { $_ => 1 } @compare_array;
foreach my $id (keys %compare) {
if (exists $seen{$id}) {
# found this id
}
else {
# didn't fi
Has someone an example for this:
(tcl-style code, I'm deeply stuck in TCL at the moment, I'm sorry ;)
set sql_statement "select blob_column,id from table for update"
execute $sql_statement
foreach $row in $sql_statement {
do_a_regular_expression_replacing on $row's $blob_column
save $blob_
Has someone an example for this:
(tcl-style code, I'm deeply stuck in TCL at the moment, I'm sorry ;)
set sql_statement "select blob_column,id from table for update"
execute $sql_statement
foreach $row in $sql_statement {
do_a_regular_expression_replacing on $row's $blob_column
save $blob_
Hello,
Please forgive in advance my ignorance. But... our company is trying to set
up some applications on Solaris using Perl DBI using DBD::Oracle. We are
currently looking for a DBA but in the meantime, none of us have any
experince configuring the machine running the perl scripts to talk to th
I have had a simular problem with solaris
Good test is to see if it dies on the exit in the test script
If this is the case it is the problem with threads in oracle
you need to edit the file in oracle called syssymlist or something like that and
remove the "-l threads"
you then reccomplie th
Thanks Ron,
Both of your solutions work. I'm still curious as to why my original code
doesn't work.
I can see why you would wonder why I'm createing seq_num the "hard way". In
the real code, the where clause is: "where serial_uid = ?". Serial_uid is a
foreign key and there is a one to many rela
Dilgeet Badial <[EMAIL PROTECTED]> wrote:
> Here is the error message I am getting:
> DBI->disconnect is not a DBI method.
Well, it isn't a DBI class method--it's a database handle method. If
your code looks like DBI->disconnect; that's the problem. You want
something like $dbh->disconnect; ins
Hi there,
I am having problems with using disconnect method with DBI version 18 on
Perl5.6. It is working on another machine which has DBI-14 and perl5.5003.
That is strange though 18 release is later than the 14 one. Is this is a bug
in 18 release of DBI or is it a Perl 5.6 thing. I am using the
I have about three work-arounds for this problem, but all of them are time
consuming and a big drain on resources. I was wondering if any of you have
come up with an easy way to compare the contents of a list (array) against a
table (Perl:DBI:MySQL).
At the risk of looking like an idiot, here is
It's documented somwhere and it's not experimental --
I've been using a DBI subclass for almost two years.
The reason for having to subclass different pieces is
that the DBI file actually contains a few related
packages. You need to subclass all of them to get things
to work.
If you get stuck
> > I'm planning on inheriting from DBI::db.
> >
> > My question is, is it safe to inherit from DBI::db?
>
> From: Mitch Helle-Morrissey [mailto:[EMAIL PROTECTED]]
>
> Look at the subclass.t test file that comes with the DBI
> distribution. In
> short, you'll need to inherit from all three DBI
On Wed, Jul 18, 2001 at 01:40:31PM -0400, [EMAIL PROTECTED] wrote:
> I'm using Perl DBI with Oracle 8.16 and I'm noticing some unexpected
> behaviour. Consider the following:
>
> select NVL(max(seq_num)+1, 0)
> from serial.price
> where price_uid = ?
> We've found two work a
I like your second solution. Group functions may ignore null values,
but you are still adding 1 to the result, so if max() is returning
null, you are adding one to a null value and '+1' is not a group function.
And you should still finish() the cursor if you are only fetching
one row, although wi
Dear list members,
I'm using Perl DBI with Oracle 8.16 and I'm noticing some unexpected
behaviour. Consider the following:
select NVL(max(seq_num)+1, 0)
from serial.price
where price_uid = ?
A problem occurs if there is a NULL value in seq_num among the group of
records
Look at the subclass.t test file that comes with the DBI distribution. In
short, you'll need to inherit from all three DBI classes: DBI, DBI::db, and
DBI::st. You'll need to use the init_rootclass() method so your constructor
returns an object of the type you created instead of a DBI::db object.
Bhuvan A wrote:
>
> how can we retrive a result of a query in pre-formatted HTML
> format in DBD::Pg??
This prints the results of a Pg (or any DBI database) query as an HTML
table:
use DBI;
my $ad_dbh = DBI->connect('dbi:AnyData:(RaiseError=>1)');
my $pg_dbh = DBI->connect( @pg_connect_valu
Matthew Wickline wrote:
>
> > The AnyData modules support tables that have a
> > single key column that uniquely identifies each
> > row as well as tables that do not have such keys.
>
> How does one insert a row into a tied-hash $table which has no key column?
Answer 1: use the DBI interface i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jul 18, 2001 at 05:59:40PM +0200, Peter J . Holzer wrote:
> Depends on the version of Bugzilla. Redhat ported it to oracle
> (unfortunately, AFAICS, they didn't make a version which works with
> both). The Oracle-Bugzilla is available from the
On 2001-07-17 12:50:13 -0500, Stephen Clouse wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Tue, Jul 17, 2001 at 10:21:13AM -0700, Blake Binkley wrote:
> > I have Oracle 8.1.7 Client installed
>
> Your first problem might be the fact that Bugzilla only works with MySQL.
Depends
On 2001-07-18 08:37:28 +, Andrew Higgs wrote:
> Jim Longino wrote:
> >
> > This message was cancelled from within Mozilla.
>
> This feature is apparently not working yet
It would work if this was a newsgroup and not a mailing list. Since
Mozilla doesn't let you cancel mails I suspect th
You probably ought to be using DBD::ODBC anyway for
Win platforms.
> -Original Message-
> From: Mahdi A. Sbeih [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 17, 2001 11:45 PM
> To: Michael A. Chase
> Cc: Dbi-Users
> Subject: RE: DBD::Informix 1.00 for Win32 platforms.
>
>
> Hi Michae
DBI (which uses DBD::Pg for access to Postgresql) handles database access,
not HTML formatting.
HTML formatting is outside the scope of this list. I suggest you look at
'perldoc CGI' and the information sources listed there and in the Perl FAQ.
--
Mac :})
** I normally forward private questions
You will have a better chance of getting a useful answer if you ask this on
the ActiveState email lists. I suggest you email them to
1. Request that they provide a pre-compiled DBD::Informix for Informix
1.00.
2. Ask them for instructions for compiling your own if they can't.
I'm fairly sure y
DBI related??? Let's keep in on-topic and direct all OT to appropriate
groups.
Ilya
-Original Message-
From: Ian Summers
To: [EMAIL PROTECTED]
Sent: 07/18/2001 4:27 AM
Subject: Re: how to run perl from MS Access Form
Hi
The easiest way is to shell out to a batch file from a command bu
Jeff Zucker wrote:
> The new version, 0.05 was released today.
cool! :)
>From the tied hash docs:
> $table->{Sue} = {country=>'de',sex=>'f'}; # insert a row
:
:
> The AnyData modules support tables that have a
> single key column that uniquely identifies each
> row as well as tables that do
Hi
The easiest way is to shell out to a batch file from a command button.
. In the form's design view add a command button.
. In the command button's On-Click property put [Event Procedure] from the
drop-down list.
. Double click just to the right of the white area (on a [...] button that
will
Jim Longino wrote:
>
> This message was cancelled from within Mozilla.
This feature is apparently not working yet
--
Kind regards
Andrew Higgs
HI,
Pallavi Patil wrote:
>
>
> Is MSAccess is okay or I should go for some other
> database?
>
You could try InterBase. It is currently available for free and runs on
windows or Linux.
--
Kind regards
Andrew Higgs
36 matches
Mail list logo