Problem

Hi I'm Satya. I'm having some problems with DBI... The following is the problem 1. I wrote a Forking Server that will Create 2 database handlers and wait for clients to connect 2. Once the client get's connected It will acquire a DB Handlers and the corresponding flag Is Set .. 3. I

Installing under windows with dmake

I get an error on line 895 in the makefile. I do not know much about makefiles, I have tried to correct the error but my limited knowledge will not allow me to. Could you please help me with this? Thank you Tom

Re: Oracle prepare failed?

Please post your entire statement: my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, . . . Thanks - Original Message - From: "Michael Ragsdale" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 17, 2001 3:00 PM Subject: Oracle prepare failed? > I have a query that

RE: Oracle field lengths

The maximum length of an index is a function of the Oracle block size. Since Oracle 8, the maximum length of a varchar2 is 4000 (no bigger even in 9i). An index entry is limited in length to 1/3 the block size, so to get an index on a varchar2(4000) column, you would need a 16K block size. Steve

Oracle field lengths

Hi all, I'm running Oracle 7.3.3 (I know, its rather old) under Solaris 2.5... With most of our tables, the maximum number of characters (varchar2) is set to 2000 - I think this is because anything longer does not allow you to perform a search on indexed fields... Do the newer versions of Oracl

RE: Oracle prepare failed?

No, they weren't. However, the username does have "select any table" privileges granted to him. I just logged into sqlplus with the same username that is in the DBI script and it did indeed work just fine via sqlplus. I'm at a loss.? At 04:04 PM 09/17/2001, Dong Wang wrote: >are the

RE: Oracle prepare failed?

are the usernames used in dbi the same as in sqlplus? Since it is a ORA-00942 error, it is possible that 1. the user connected through dbi does not own the table 2. there is no synonym created for the dbi user so that tables have to be qualified as schema.table_name 3. there is no select privile

Extracting FileMaker data

Hi Has anyone extracted data from FileMaker on a Windows platform? What module does it require - DBI:ODBC ? Ian ++ This email and any files transmitted with it are confidential and intended solely for the use of the individual or

Oracle prepare failed?

I have a query that works just fine in Oracle SQL*Plus, but I receive the following error when run through DBI. Line 35 states: my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, I'm running: Redhat 7.1, Perl 5.6.0, DBI 1.14, DBD::Oracle 1.06 Here is t

Re: [PATCH] AutoCommit support for DBD::Proxy

Great. Thanks. Tim. On Mon, Sep 17, 2001 at 04:32:41PM +0200, Jochen Wiedmann wrote: > > Hi, Tim, > > the following patch should enable support for AutoCommit > in DBD::Proxy. The problem was, that the handling of > AutoCommit was left to the superclass (DBI::_::db), which > refuses to handle

Re: dbd::db2 beginner question

The DB2 SDK v5.2 and ADC v6 or greater are free for download from: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download.d2w/report This site contains full install images of the clients. Regards, Michael Bill Grigg <[EMAIL PROTECTED]> on 09/14/2001 03:52:49 PM Please r

Re: ORA-01801 problem again

Sterin, Ilya <[EMAIL PROTECTED]> [010917 08:07]: > Have you tried outputting the query (print() it) and see exactly what you > are getting. Running that through sqlplus might also help. This is really > not a DBI/DBD problem, but might be an Oracle config problem or the query > you are submittin

RE: ORA-01801 problem again

Have you tried outputting the query (print() it) and see exactly what you are getting. Running that through sqlplus might also help. This is really not a DBI/DBD problem, but might be an Oracle config problem or the query you are submitting is different than what you are expecting. HTH Ilya

Re: ORA-01801 problem again

Hi, This looks like bug#1112313. See oracle for a patch. If you search metalink you will find others who've encounter this bug. You may need to get a patch. Michael bug#1112313 WHEN PROC APLICATION IS EXCUTED ,ORA-1801 OCCURS. > The important variables are set: > $dbh->{LongRea

ORA-01801 problem again

Environment: SunOS 5.5.1 Generic_103640-36 sun4u sparc SUNW,Ultra-2 Oracle Enterprise Server 8.0.5 (on remote SunOS) DBI 1.20 (all tests OK) DBD::Oracle 1.12 (all tests OK) Hi, I decided to present my problem again. Nobody answered my question, but I still believe there are clever people who ca

Re: ANNOUNCE: DBD::Oracle 1.12

I'll let those motivated by actual need do the work and send me a tested patch :) Thanks. Tim. On Sun, Sep 16, 2001 at 05:19:35PM +0100, Nick Gorham wrote: > Tim Bunce wrote: > > > For VMS I need tested patches - I'm not able to test on VMS myself. > > > > Tim. > > Not sure if you want to know

RE: PERL , DBI , Oracle - how to accept output from a PL/SQL procedur e that returns multiple rows

I may be wrong here, but I don't think DBD::Oracle can cope with PL/SQL tables or VARRAYs. Go with REF cursors. There are examples of passing back cursors from a PL/SQL block in the DBD:Oracle docs. The principle is the same for REF cursors returned from a stored procedure. Here's a quick examp

Re: DBI , Oracle - how to accept multiple rows returned by a PL/SQL s tored procedure

Hi Andrey, > I'm considering to write a PL/SQL procedure that returns multiple rows (most > likely via REF cursor , although i might think of PL/SQL tables or VARRAYs) > How can i accept such an output in PERL script ? You could try the private DBMS_OUTPUT methods available via DBD::Oracle, and

Re: Commercial application

On Mon, 17 Sep 2001 00:08:00 -0700 (PDT), saravanan raj wrote: >I want to develop one commercial application in perl >which uses DBI interface for datbases like >oracle/mysql... > >i need to know how i can distribute the >application(without giving the source code) and how >can i make a setup pro