You're right,

the call to the Stored Procedure was ok. The problem comes from an ORDER BY
which appears there. The procedure is as follows:

AS
begin
/* Procedure Text */
FOR
SELECT "Spot"."ArrayRow", "Spot"."ArrayColumn",
"Spot"."Row","Spot"."Column", "RawData"."Intensity", "RawData"."Background",
"RawData"."Area"
FROM "Spot", "RawData"
WHERE "RawData"."SpotId" = "Spot"."SpotId" AND
("RawData"."HybridizationId" = :hybid1 or
"RawData"."HybridizationId" = :hybid2)
ORDER BY "ArrayRow", "ArrayColumn", "Row", "Column"
INTO :arrayrow, :arraycolumn, :subrow, :subcolumn, :intensity,
:background, :area
DO
SUSPEND;
end

Where hybdb1 and hybdb2 are the two input parameters of the SP (integers).

If I take out the ORDER BY everything works fine, but If I leave it there,
then the error appears:

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

What does this error mean? Is it a problem of indexes? I need this ORDER BY!!!

Please could anyone help me?

Xavier.


A Divendres 08 Març 2002 06:17, vàreu escriure:

> 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/
>
>
>
>
> 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/

--
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