Today is my first day on the email list so I missed that thread.
I attempted to access an archive but the one I could find was unreachable.
The only binary for Solaris 8 that I found was perl 5.6.1 and I would prefer
5.005_02 or 03.
If you could point me to any appropriate documentation, it wou
Matthew Dougherty wrote:
> I installed GCC and when executing make the first error is as follows:
>
> I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c
> cc: unrecognized option `-KPIC'
Either build your Perl with GCC, or read up on the recent answer on this list
telling you where to
Rajeev Nalluri wrote:
> Recently the server got upgraded from Informix7.x to Informix 9.21. Do I
> need to upgrade Perl DBI/DBD also? Please let me know how can I do it.
Whether you have to do it depends on a lot of circumstances, all of them under your
control but you have
to know what you are
Result here: (I put iteration number in output)
55361
55362
55363
55364
55365
Out of memory!
Out of memory!
Callback called exit.
Out of memory!
I'm using a bit old copy of DBD::Pg, but I don't think it makes a
difference. Please check that you have ample memory, and no ulimit in
effect when you
Hi
- Original Message -
From: "Rajeev Nalluri" <[EMAIL PROTECTED]>
Sent: Monday, October 08, 2001 12:18
> I think I may need to either re-install DBD or re-compile
> DBD with the new Informix PATH.
Or you need someone to put those files in the same place[s] the first
ones were.
> Can yo
I installed GCC and when executing make the first error is as follows:
I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c
cc: unrecognized option `-KPIC'
You can see the raw output here:
nj-lb-sun_root# export PATH=/usr/local/bin:/usr/ccs/bin:/usr/bin
nj-lb-sun_root# make clean
rm -r
Hi, Harrington,
Do you know if there is a limit of how many rows it could return ? I read
somewhere that there is 64K limit
on the in and out parameter ?
Thanks a lot,
Jie
Harrington Michael wrote:
> Jie,
>
> Stored procedures can return multiple rows. Personally, I just step thru
> the
Thanks Mark. Actually it is a SQL Server. The content in the database is
of nVarchar, nText, etc. so things are being stored as doublebyte...
Do you know how this would appply there?
Appreciate the help,
Nikko
-Original Message-
From: Mark Vandenbroeck [mailto:[EMAIL PROTECTED]]
Sen
Nikko,
Depending on what you are trying to do, it might not really matter whether
DBI supports Unicode or not.
Oracle always does a characterset translation between client and server. It
translates data coming from the server to the characterset specified in your
NLS_LANG environment variable. It
Jie,
Stored procedures can return multiple rows. Personally, I just step thru
the array that fetch brings back to work with the rows. Works like a charm!
> -Original Message-
> From: jie zhang [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 08, 2001 3:17 PM
> To: [EMAIL PROTECTED
Jie,
Stored procedures can return multiple rows. Personally, I just step thru
the array that fetch brings back to work with the rows. Works like a charm!
Thanx people, that really helped :)
Glad on that list
> -Original Message-
> From: Rozengurtel, Daniel
> Sent: Monday, October 08, 2001 5:16 PM
> To: '[EMAIL PROTECTED]'
> Subject: Insert
>
> Hello people,
>
> I am having hard time inserting something into my table. This is wha
> my $rows_inserted = $dbh->do(q{
> INSERT INTO CMO_MONDAY values ($record[13],
> 'ttt', 'sss', 'sss',
> 'sss', 'sss', 'sss', 'sss', sysdate, 'sss')
> }) || die $dbh->errstr;
> exit;
Take a look at 'perldoc perlop' and read up on the diffe
Oracle string values need sigle quotes 'STRING'.
I think good practice to have all the column names while you are inserting the values
into table.
Insert into emp_table (id, name) values (1234,'$myname')
--Raju
-Original Message-
From: Rozengurtel, Daniel [mailto:[EMAIL PROTECTED]]
S
I am having trouble building DBI-1.20 on Solaris 8 using GCC or
/usr/ccs/bin/cc.
I have set my path to use /usr/local/bin first and also with /usr/bin
first.
I intend to use the mysql and ODBC DBD modules as well.
I am sure this has been disucssed but the archives have not been
reachable.
Any
Hello people,
I am having hard time inserting something into my table. This is what i do:
my $rows_inserted = $dbh->do(q{
INSERT INTO CMO_MONDAY values ($record[13], 'ttt', 'sss', 'sss',
'sss', 'sss', 'sss', 'sss', sysdate, 'sss')
}) || die $dbh->errst
> I think you need to do like this,
>
> $dbh = DBI->connect($connect_str);
> $dbh->{LongReadLen}=65000;
> $dbh->{LongTruncOk}=1;
>
> That should work, I didn't tried with BLOBs but I used with CLOBs, it's
> working fine.
Thanks for the quick reply Raju!
Sorry, I should have i
On Mon, Oct 08, 2001 at 09:39:16AM -0500, Harrington Michael
<[EMAIL PROTECTED]> wrote:
> Greetings, all...
>
> Will word this differently again and hope it strikes a chord with one of
> you techno-gods...
>
> Using DBI::DB2 v 0.75, I can
>
> - return parameters from stored procedures
> -
I think you need to do like this,
$dbh = DBI->connect($connect_str);
$dbh->{LongReadLen}=65000;
$dbh->{LongTruncOk}=1;
That should work, I didn't tried with BLOBs but I used with CLOBs, it's working fine.
Raju
-Original Message-
From: Darren Nickerson [mailto:[
Folks,
I'm trying to return a BLOB (a PDF file, actually) from an ORACLE function as
follows:
my $doc_id = "12345";
my $rv;
my $sth = $dbh->prepare(q{
BEGIN
:rv := GET_PDF(:doc_id);
END;
});
$sth->bind_param(":doc_id", $doc_id);
$sth->bind_pa
Hi,
Can stored procedure return mutiple rows of a select statement ? In
another word, could I have collection or
varrys as out paramters ? If yes, is it recommended
to use stored procedure in this case or I should just use sql statements
?
Thanks in advance,
Jie
Trying to get DBI to select from a database with unicode characters
Anyone out there successfully know of what I need to do to get unicode
data out of a database? I've seen a lot of postings on the net with
people having issues with this my result set gets ?
instead...
It seems to be
Hi All,
Recently the server got upgraded from Informix7.x to Informix 9.21. Do I
need to upgrade Perl DBI/DBD also? Please let me know how can I do it.
Regards,
Rajeev Nalluri
Thanks Mark. That did it.
On Sun, 2001-10-07 at 06:00, Mark Thornber wrote:
> Dave,
>
> The bundled Perl is compiled with Sun's cc compiler. You will need to
> use that to compile and DBI / DBD modules.
>
> The recommended action (mentioned elsewhere in this mailing list and on
> www.sunfre
Thanks Mark,
I know why we got this problem. Last weekend we upgraded the informix
server to 9.21. I think I may need to either re-install DBD or re-compile
DBD with the new Informix PATH. Can you please tell me how can I recompile
the DBD with the new INFORMIX variables.
Regards,
Rajeev Nallu
Rajeev,
Rajeev Nalluri wrote:
> Hi,
> I am getting an error? Can somebody explain why I am getting this error.
> What this error code means? Even though it is giving this error, its
> getting the data fine. No problems with the data its retreiving, but only
> throwing an extra error. In which ca
Hi,
I am getting an error? Can somebody explain why I am getting this error.
What this error code means? Even though it is giving this error, its
getting the data fine. No problems with the data its retreiving, but only
throwing an extra error. In which cases we get this error?
DBD::Informix::st
Greetings, all...
Will word this differently again and hope it strikes a chord with one of
you techno-gods...
Using DBI::DB2 v 0.75, I can
- return parameters from stored procedures
- return a result set from stored procedures
But cannot seem to figure out how to reurn multiple result set
Richard,
> Hello,
>
> I'm brand new to this group and I have a question (If this isn't the
> group for asking questions about using the Perl, MySQL, and DBI can
> someone point me in the right direction.)
>
> I have an existing script that writes information to a text based
> database and sends
Francesc Guasch Ortiz wrote:
>
> I'm trying to use DBD::AnyData and I see it's way slow.
It is faster in RAM mode, but if you need speed you should be using a
full rdbms system or DBM, not text files.
> I wanted to add index or primary keys to the tables but
> I couldn't.
The module does not s
Mike,
Type in 'ldconfig -r' on the command line, look for :
221:-lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10
If you don't try,
'ldconfig -m /usr/local/lib/mysql/libmysqlclient.so.10'
and try to compile DBD::mysql again.
On 05-Oct-0
I'm trying to use DBD::AnyData and I see it's way slow.
I wanted to add index or primary keys to the tables but
I couldn't. I tryed lots of things:
create table table_name (
id int(11) not null primary key
);
create index id (id)
Is there a way to do this ?
I wanted to do the tests for a mo
Study
t/subclass.t
in the distribution.
Tim.
On Sun, Oct 07, 2001 at 10:47:54PM -0700, Jared Still wrote:
>
> I'm having a little trouble with subclassing DBI
> when used with Oracle. After upgrading DBI and DBI::Oracle
> the other day, some code I was working on no longer worked.
>
Hi All
Does anyone have any experience building DBD::Informix for the Windows platform
?
I have managed to get through the perl Makefile.PL and an nmake which does not
seem to return any errors but when I do the nmake test I get over 90% failures
with each failure generating the errors similar
34 matches
Mail list logo