Re: DB connection sharing w/o DBI?

Sorry to hear it. Sounds like maybe someone wants this solution to fail and is sabotaging it so it can be implemented some other way. You could pipe sql to SQL*Plus and read the results back out, it's kind of kludgy and slow but I did the same thing with Informix (piping to Informix's dbaccess) awhile back when it was taking a long time to get someone to install the Informix SDK (a prerequisite for DBD::Informix). I tried to batch the commands as much as possible so I wouldn't have to essentially connect to the database too many times. In fact, to be efficient, it might be worthwhile to just code alot of it in PL/SQL if you can't whack any sense into someone with a heavy clue x 4.

Comment on Re: DB connection sharing w/o DBI?

Replies are listed 'Best First'.
(jptxs) Re: DB connection sharing w/o DBI? by jptxs (Curate) on Nov 04, 2001 at 23:26 UTC
you're close =] It's actually a large political war I'm trying to side-step. Short version is I'm taking functionality we have in one place and putting it in another because it makes sense. The official channels for getting that done are too busy arguing over who's got the bigger, errr.. I mean, who's going to get the credit. I figure if I just do it then the arguing becomes moot. But I have to do it without any official help, which means no altering the servers in any way I cannot as my own ID...fun, eh? We speak the way we breathe. --Fugazi	[reply]
Re: (jptxs) Re: DB connection sharing w/o DBI? by runrig (Abbot) on Nov 05, 2001 at 05:10 UTC
no altering the servers in any way I cannot as my own ID.. Well, you can always install into your own directories by running 'perl Makefile.PL PREFIX=/home/myhomedirectory/perl/lib', and then making sure that the directories and files are readable by everyone, and using 'use lib qw(/home/myhomedirectory);' in all the scripts you write (that's assuming you're doing the make/make test/make install thing instead of using the CPAN module or downloading an ActiveState PPM or ...?) :-)	[reply]