Re: Stored procedures
| From: | Martin Marques | Date: | Wed, 12 May 2004 22:03:21 +0000 |
| Subject: | Re: Stored procedures | ||
| References: | 1 2 3 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-12448@lists.php.net to get a copy of this message | ||
El Mié 12 May 2004 18:06, Justin Patrin escribió:
> Martin Marques wrote:
> > El Mié 12 May 2004 17:02, María José Reartes escribió:
> >>Hi
> >>
> >> I need to invoke an oracle stored procedure from PHP and
> >>through PEAR. Is this possible? Does anyone know how?
> >
> > Aren't Oracle SP called throught the select clause?
> >
> > SELECT my_func();
>
> Yep. Just do:
> SELECT function(params) FROM DUAL
If I'm not wrong this was add in the SQL99 standards.
--
19:00:01 up 14 days, 22 min, 1 user, load average: 0.28, 0.45, 0.41
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------