You can only do this the function has no side effects, or the PRAGMA RESTRICT REFERENCES clause is used. I forget exactly what is required but as far as I remember its quite restrictive.
Ken. > -----Original Message----- > From: Steve Haslam [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2003 10:51 > To: 'David Bakkers'; [EMAIL PROTECTED] > Subject: RE: Newbie problem with Oracle functions > > > >eval { > > my $func = $dbh->prepare(q{ > > BEGIN > > :retval := SPISFINANCIAL( > > parameter1_in => :parameter1 > > ); > > END; > > }); > > > > $func->bind_param(":parameter1", '123456'); > > $func->bind_param_inout(":retval", \$retval, 6); > > $func->execute; > > $dbh->commit; > >}; > > You could just write: > > my $sth = $dbh->prepare("SELECT spisfiniancial(?) FROM dual"); > $sth->execute(123456); > my $retval = $sth->fetchrow_arrayref->[0]; > > -- > Steve Haslam, Developer for Activis; Integralis Ltd, Theale > http://www.activis.com/ > > > Please note that: > > 1. This e-mail may constitute privileged information. If you > are not the intended recipient, you have received this > confidential email and any attachments transmitted with it in > error and you must not disclose, copy, circulate or in any > other way use or rely on this information. > 2. E-mails to and from the company are monitored for > operational reasons and in accordance with lawful business practices. > 3. The contents of this email are those of the individual and > do not necessarily represent the views of the company. > 4. The company does not conclude contracts by email and all > negotiations are subject to contract. > 5. The company accepts no responsibility once an e-mail and > any attachments is sent. > > http://www.activis.com > > > > > This annotation was added by the e-scan service. > http://www.activis.com > -------------------------------------------------------------- > -------------------- > This message has been checked for all known viruses by e:)scan. > For further information please contact [EMAIL PROTECTED] >
