On Wed, 27 Aug 2003 14:48:25 +0200, Peter J. Holzer wrote:
Hi Peter
my($s) = Data\n\r;
Erm, that should be Data\r\n, at least on MS-DOS/Windows and all
line-oriented Internet protocols I'm familiar with (telnet, smtp,
nntp, http, imap, ...).
Nope. It should be \n\r as stated. I knew
On Tue, Aug 26, 2003 at 09:33:58AM -0700, Jeff Zucker wrote:
Thomas A. Lowery wrote:
know if you have other ideas that wouldn't break existing scripts.
What was I thinking ... break every CSV process in the world using
DBD::CSV. sigh
DBD::CSV expects by default. You need to either add the
Hi,
1. Could someone please lend me the benefit of their knowledge
regarding an oracle error I received when I was attempting to connect to
an oracle database via a perl script? Actually I got two errors on that
told me that the 'old style' syntax for connecting wouldn't be
supported
on DBI 1.37, DBD::Oracle 1.14 on SunOS with perl 5.8.0 and gcc 2.95.3
Assuming I never actually call disconnect() and I'm
running under Apache 1.3.27, Apache::DBI, and mod_perl 1.27
what could cause this error ?
DBD::Oracle::db prepare failed: ERROR Database disconnected [for statement ``sql
What is best language to use to power web server and MySQL. Per or PHP,
if doing online book store ??
Thanks
Cong yan
Hi,
Does anybody know how I can call a oracle PL/SQL function in PERL? Below
is my perl code :
use DBI;
my($db, $csr, $ret_val);
# Connect to an Oracle database.
# db userid and password
$db = DBI-connect('dbi:Oracle:ctsdv2','apps','s0mm3r')
or die Unable to connect:
First, I think Jeff is right. We're getting a bit off-topic here.
On 2003-08-28 09:01:59 +1000, Ron Savage wrote:
On Wed, 27 Aug 2003 14:48:25 +0200, Peter J. Holzer wrote:
my($s) = Data\n\r;
Erm, that should be Data\r\n,
Nope. It should be \n\r as stated. I knew someone would fall
I don't know what your SQL code does, frankly, as I'm a MySQL bod and we
don't tend to deal with magic like that :-)
But I think that you're doing $csr-finish too early. Don't you want to
retrieve some information from the cursor before ditching it?
Or else, if it's as I guess and you're just
On Wed, Aug 27, 2003 at 04:24:36PM -0400, Kelly Harrelson wrote:
Thanks for that valueable tip. It seems to be stuck on line 95 of the
Makefile:
my $is_me = (-d /home/timbo/dbi ($ENV{LOGNAME})||'') eq 'timbo');
Any guesses? My LOGNAME is set to the same account that installed
perl5.8.0 and
On Wed, Aug 27, 2003 at 09:44:47PM -0400, Philip M. Gollucci wrote:
I don't have the trace file handy, but the next time it happens, I can
grab it and post it if needed.
Won't get far without it.
Tim.
On Thursday 28 Aug 2003 3:06 am, cong yan wrote:
What is best language to use to power web server and MySQL. Per or PHP,
if doing online book store ??
Thanks
Cong yan
Hi,
I think asking this on a Perl based list (I don't think DBI is available for
PHP) I think you'll get a biased answer.
Abhilash Shah (abshah) wrote:
Does anybody know how I can call a oracle PL/SQL function in PERL?
Yes - do it all the time :-)
Below
is my perl code :
[Snip]
$csr = $db-prepare(
declare
type abc refcursor;
Don't
Jared Still [EMAIL PROTECTED] writes:
If you are working with Oracle, or any database for that matter,
one of the cardinal performance rules for programming is to do
it in SQL in possible. It is much faster than anything you
can write in Perl, or any other language for that matter.
This
Zachary Buckholz [EMAIL PROTECTED] writes:
But since my perl code runs from the crontab sometimes jobs overlap
and I might be popping mail for more then one site's feedback address
at a time and thus making multiple inserts into the MS SQL database
server. Then I get these damn deadlock
hi list
i am a new member of the perl developer community and like to ask the
following question:
How am i supported by dbi? am i right suggesting, that the following
scenario abstracts what it can do (also):
OracleDB
--- oracleDriver
--- StoresSession2DB dbi
--- Apache::Session
---
I've upgraded to V 0.28, and the module now compiles, links, tests and installs ok.
It's a bit carelessly coded, in that there are a few places where type conversions are
not added explicitly to stop compiler warnings, but barring that, the tests all pass,
so I feel it is time to try a few
Hi,
I got problems with installing DBD::Oracle-1.14
I've attached 2 listings with: 'perl Makefile.PL' 'make' commands I
did
Probably, you'll suggest me something.
Thank you.
Dmitriy Kovalev
Abhilash Shah (abshah) wrote:
Does anybody know how I can call a oracle PL/SQL function in PERL?
Various examples in the documentation:
http://theoryx5.uwinnipeg.ca/CPAN/data/DBD-Oracle/Oracle.html#PL%2fSQL_Examples
$csr = $db-prepare(
declare
type abc refcursor;
I think
W licie z ro, 27-08-2003, godz. 22:24, Kelly Harrelson pisze:
Thanks for that valueable tip. It seems to be stuck on line 95 of the
Makefile:
my $is_me = (-d /home/timbo/dbi ($ENV{LOGNAME})||'') eq 'timbo');
# a reasonable guess
Any guesses? My LOGNAME is set to the same account that
Thomas A. Lowery wrote:
To start shell I use: dbish dbi:CSV:f_dir=.;csv_eol=\n
My guess is that you are somehow turning the eol character into a
literal slash + char n and that is causing all of the following
problems.I notice for example that using dbish to manually set a DSN, it
only
Thanks Tim! I had not even thought of that simple test. Sure enough,
the ls hangs. Your solution got me past that point and I've now finished
the build and have run a sample dbi script. I appreciate the help.
Kelly Harrelson
Database Administration
North Carolina State University
919.513.7229
On Wed, 27 Aug 2003 14:45:00 -0700, Zachary Buckholz wrote:
But since my perl code runs from the crontab sometimes jobs overlap and I
might be popping mail for more then one site's feedback address at a time
and thus making multiple inserts into the MS SQL database server. Then I
get these
Unless I'm mistaken, this is 2 runs through. The first fails with the
error. The second works.
Thanks in advance.
T - STORE('RaiseError' 1)= 1 at AMSDBI.pm line 148
T - STORE('LongReadLen' 5)= 1 at AMSDBI.pm line 151
T - STORE('LongTruncOk' 1)= 1 at AMSDBI.pm line 152
T -
Thank You, we had a similiar trigger issue two weeks ago and it took several
days to figure it out. This was the first thing I asked the DBA yesterday he
said no there are no triggers.
I went to the other DBA this morning and asked him to look and he said yes.
You were right
Hi
I am going to publish (scientifically) a database which we have built
at our department. It uses, among other things, DBI. How should I cite
DBI - has it been published?
Yours,
Jonas
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design
Ahhh, my favorite error code, the infamous 1205. Obviously the insert
statement is not the problem, its the trigger that is being called.
Please provide source for the trigger and perhaps I can help.
Chuck
[EMAIL PROTECTED] wrote:
I have a small perl script using DBI and DBD::Sybase as well
On Thu, Aug 28, 2003 at 10:07:04PM +1000, Ron Savage wrote:
I've upgraded to V 0.28, and the module now compiles, links, tests and installs ok.
It's a bit carelessly coded, in that there are a few places where type conversions
are not added explicitly to stop compiler warnings, but barring
Attachments didn't make it.
On Thu, Aug 28, 2003 at 03:40:35PM +0400, Dmitriy Kovalev wrote:
Hi,
I got problems with installing DBD::Oracle-1.14
I've attached 2 listings with: 'perl Makefile.PL' 'make' commands I
did
Probably, you'll suggest me something.
Thank you.
Dmitriy Kovalev
On Thu, Aug 28, 2003 at 11:22:09AM -0400, Philip M. Gollucci wrote:
Unless I'm mistaken, this is 2 runs through. The first fails with the
error. The second works.
Thanks in advance.
Use a higher trace level, say 3, and post the trace from the last
method that accessed the databases to the
Dear Gurus,
I am having problems with updating my Oracle table when changing one table's
column data type from VARCHAR2 to CHAR.
This particular column is in WHERE statement for an update. If it was left
as VARCHAR2 I would have no problems. However I need this data type be
persistent so that I
On Thu, Aug 28, 2003 at 09:01:48AM -0700, Jonas Andersson wrote:
Hi
I am going to publish (scientifically) a database which we have built
at our department. It uses, among other things, DBI. How should I cite
DBI - has it been published?
You could refer to...
the book:
Hi,
What could be the possible causes for the following error? Any info would
be greatly appreciated.
Thanks,
John
OpenClient message: LAYER = (7) ORIGIN = (2) SEVERITY = (6) NUMBER = (6)
Message String: ct_con_alloc(): unable to get layer message string: unable
to get origin message
On Thursday, 28 August 2003, at 19:45PM, Tim Bunce wrote:
On Thu, Aug 28, 2003 at 10:07:04PM +1000, Ron Savage wrote:
I've upgraded to V 0.28, and the module now compiles, links, tests
and installs ok.
It's a bit carelessly coded, in that there are a few places where
type conversions are not
Larry,
Including a snip or two of code helps.
An example of a connection:
If using sqlplus you do: sqlplus scott/[EMAIL PROTECTED]
then for dbi you do:
my $dbh = DBI-connect( q{dbi:Oracle:db}, q{scott}, q{tiger},
{RaiseError = 1} ) or die Unable to connect $DBI::errstr\n;
34 matches
Mail list logo