You could try something like:
$sth = ibase_query("EXECUTE MY_PROC_NAME MY_PROC_ARGS");

However, I do not think the error you received is related to the query.

Greetings,
Don Schoeman


-----Original Message-----
From: Xavier Solé [mailto:x.sole@...]
Sent: 08 March 2002 19:02
To: ib-support@yahoogroups.com
Subject: [ib-support] Call Interbase Stored Procedure from PHP


Hello,

Could anyone tell me how can I call an Interbase Stored Procedure from a PHP
script? I've tried this:

$sth = ibase_query("SELECT * FROM MY_PROC_NAME(MY_PROC_ARGS)");

and I receive this Interbase error message:

Warning: InterBase: I/O error for file "" Error while trying to open file
No
such file or directory sort error in
/usr/local/apache/htdocs/hybdb/hybridization_raw_proc.php on line 84

The Stored procedure works fine, because I have executed it in programs such
as IB Expert or IBAccess.

I would be grateful if you could help me.

Thank you,

Xavier.

--
Xavier Solé Acha (mailto:x.sole@...)
Servei d'Epìdemiologia i Registre del Càncer
Institut Català d'Oncologia
Av. Gran Via km. 2,7
08907 L'Hospitalet de Llobregat, Barcelona
Tel: +34 932 607 401
Tel: +34 932 607 787


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/