Re: Stored procedures

María josé reartes wrote:

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? Thanks Majo -----Original Message----- From: Justin Patrin [mailto:papercrane@reversefold.com] Sent: miércoles, 12 de mayo de 2004 18:07 To: pear-general@lists.php.net Subject: Re: [PEAR] Stored procedures 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

What exactly does your SQL look like? If you need to use parameters, you may have to use the oracle bind functions in PHP (not sure how to use them in PEAR::DB myself). -- paperCrane <Justin Patrin>