e second? Are there others I should have included?
Thanks for any help,
Scott Smith
#
$remote_dbh =
$c->call_class_method('DBI','connect',"dbi:Oracle:OWSERV1",'','');
print "$remote_dbh\n";
if (defined $remote_dbh) {
my $sth = $remote_dbh->prepare("select
Try RMI::Client::ForkedPipes. Have the child process use one lib, and
the parent use the other. The child can give back with one DBI/DBD, and
the parent can produce handles from the other.
This is effectively the proxy solution, but you're just forking and
proxying to a private sub-process y
Hi Brian,
What was the return value of execute()?
Was there a DBI error message set afterward? ($sth_upd[$_]->errstr)
You're right that passing undef should work just fine as one of the
execution params should translate into a NULL on the database side.
Yeah, as long as it's in the 1st or 2n
I think his issue is getting list to the server side without
concatenating strings.
You can't use bind variables as table names or column names.
You may be able to write a stored procedure which takes a table name as
a variable, does the string concatenation on the server side, and uses
Orac
Tim Bunce wrote:
On Fri, May 04, 2007 at 08:15:53AM -0500, Scott Smith wrote:
Doing "set transaction read only" on Oracle has additional side-effects
besides making the connection unable to write: it switches the read
consistency level from per-statement (the default) to per-t
acle must reverse out all changes since your "set trans.."
statement with each query, and might result in a "snapshot too old" error.
I don't know if/how other databases implement this feature, and give it
such a possibly misleading name. Does anyone else?
Scott Smith
the variable setting or override in your general shell
session. i.e.
LD_PRELOAD=/usr/lib/special_old_library.so /usr/bin/oldprogram
Scott Smith
Genome Sequencing Center
routine
check the data type of fields passed-in and handle boolean values
specially, for instance, in a generic way. We use these and actual
queries to the data dictionary of the given database to make the SQL
writer "smart".
Scott Smith
Informatics
Genome Sequencing Center
Washington Univ
rdbms.mk earlier but make didn't work and
there were some strange things in the makefile.
Please reply personally.
Scott Smith
NYS Task Force on Reapportionment
_
Surf the Web without missing calls! Get MSN Bro
10 matches
Mail list logo