Google is your friend. http://www.google.com/search?hl=en&safe=off&as_qdr=all&q=DBD%3A%3AProxy+bind_param_inout+bunce+patch
Tim. On Mon, Apr 08, 2002 at 10:17:47AM +0100, Ben Lowe - RMC EMEA - Web Developer wrote: > Hi, > > I have repeated my original post below. Does anyone on here know if it is > possible to use inout parameters using DBD::Proxy ? Is this a specific problem > with oracle ? What I would like to do is to execute an oracle stored > procedure and return back a primary key or an error message.Has anyone found a > way to do this if you can't use inout parameters ? > > cheers Ben > ------------- Begin Forwarded Message ------------- > > Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm > List-Post: <mailto:[EMAIL PROTECTED]> > List-Help: <mailto:[EMAIL PROTECTED]> > List-Unsubscribe: <mailto:[EMAIL PROTECTED]> > List-Subscribe: <mailto:[EMAIL PROTECTED]> > Delivered-To: mailing list [EMAIL PROTECTED] > Date: Fri, 5 Apr 2002 09:55:43 +0100 (BST) > From: Ben Lowe - RMC EMEA - Web Developer <[EMAIL PROTECTED]> > Subject: DBD::Proxy connecting to Oracle using PL/SQL and stored procedures > To: [EMAIL PROTECTED] > > Hello, > > This is my first post to this list. I need to be able to run PL/SQL and > oracle stored procedures using the perl DBI. I am using the DBD::Proxy > driver to connect to the oracle server on another host. I cannot get > the following simple code to work. > > my $p1; > my $csr = $dbh->prepare(q{ > begin > :test := 1 * 2; > end; > })or error(new CGI,$DBI::errstr); > > $csr->bind_param_inout(':test', \$p1, 50) or error(new CGI,$DBI::errstr); > $csr->execute() or error(new CGI,$DBI::errstr); > print $p1; > > > Whenever I try to use placeholders I get the > following error: > > Argument ":test" isn't numeric in subtraction (-) at > /usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBD/Proxy.pm line 536. > > Is it not possible to get a return value using DBD::Proxy ? I have tried using ? > placeholders and this works for passing values to the statement but when > I try and get a value back nothing happens. Is this a limitation in DBD::Proxy ? > > cheers Ben > > > > > ------------- End Forwarded Message ------------- > > > ====================================================== > Ben Lowe, [EMAIL PROTECTED] > > Phone: +44 (0)1506 673425 5-digit shortdial: x73425 > > Web Developer EMEA Remote Monitoring Centre > > LINLITHGOW,UK > ====================================================== > >