Re: Stored procedures
| From: | Martin Marques | Date: | Thu, 13 May 2004 14:21:33 +0000 |
| Subject: | Re: Stored procedures | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-12466@lists.php.net to get a copy of this message | ||
El Jue 13 May 2004 09:44, María José Reartes escribió:
> Didn't work...
> I'll tell you what I'm doing so far:
> - I'm connecting to the oracle database from PHP
>
> $dsn = "oci8://$user:$pass@$db_name";
> $db = DB::connect($dsn);
>
> - I've previously created a stored procedure "PRUEBA_PHP" which inserts
> a row into the table "EMP"
>
> Now, I need to invoke "PRUEBA_PHP" from my PHP application. I'm using
> PEAR database packages (DB).
> I've tried to call "PRUEBA_PHP" doing a $db->query but didn't work
> either..
> So, any other idea?
$res = $db->query("SELECT PRUEBA_PHP(ANY_ARGS)");
var_dump($res);
--
11:20:01 up 14 days, 16:42, 1 user, load average: 0.37, 0.63, 0.70
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------