If you are using DBI::SQL_INTEGER, ':sql_types' needs to be imported, i.e. use DBI qw(:sql_types);
On Sun, 2005-12-11 at 18:45 -0500, Patrick Danley wrote: > I am new to DBI, Perl, and SQL and I am currently trying to piece > together a group of bioinformatic programs. In running the database > element of the package, I recieve a number of : > > Bareword "DBI::SQL_INTEGER" not allowed while "strict subs" in use > errors (a full listing of the error is pasted below). > > Does anyone have experience with this error and/or suggestions on how > i might resolve it? > > I am truly a novice, 3 days in, so simple explanations would be > especially appreciated. > > > > > I'm running : > > Perl 5.8.6 > dbi-pm 5.8.6 > PostgreSQL -perl-586 > Mac OS 10.4.2 > > > > > > Bareword "DBI::SQL_INTEGER" not allowed while "strict subs" in use > at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Bareword "DBI::SQL_SMALLINT" not allowed while "strict subs" in use > at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Bareword "DBI::SQL_DECIMAL" not allowed while "strict subs" in use > at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Bareword "DBI::SQL_FLOAT" not allowed while "strict subs" in use at / > sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Bareword "DBI::SQL_REAL" not allowed while "strict subs" in use at / > sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Bareword "DBI::SQL_DOUBLE" not allowed while "strict subs" in use at / > sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Bareword "DBI::SQL_NUMERIC" not allowed while "strict subs" in use > at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 1168. > Compilation failed in require at /Users/TheBucket/lib/Perl/PartiGene/ > PG_db.pm line 6. > BEGIN failed--compilation aborted at /Users/TheBucket/lib/Perl/ > PartiGene/PG_db.pm line 6. > Compilation failed in require at /Users/TheBucket/genome/bin/ > PartiGene_db.pl line 4. > BEGIN failed--compilation aborted at /Users/TheBucket/genome/bin/ > PartiGene_db.pl line 4. > > > > Patrick Danley, Ph.D. > > Postdoctoral Researcher > Department of Biology > University of Maryland > > phone 301.405.8303 > fax 301.314.9358 > email [EMAIL PROTECTED] > http://www.life.umd.edu/biology/shawlab/patrickdanley > > > > -- Scott T. Hildreth <[EMAIL PROTECTED]>