I'm trying to work around the problem, and hacking a view that uses the
stored procedure:

CREATE VIEW V_BUYOUT_CANDIDATES2
(
ACCOUNTID,
SRVPROVID,
NDC9,
GPI,
TEE,
DOSE,
BUYOUT_QTY,
LABELNAME
) AS
SELECT
p.ACCOUNTID, p.SRVPROVID, p.NDC9, d.GPI, d.TEE, d.UNIT_DOSE_USE,
SUM(p.QTY),
(SELECT FIRST 1 d1.LABELNAME FROM MDDB_DRUG d1 WHERE
d1.PRODUCTID/100=p.NDC9 AND d1.GPI=d.GPI AND d1.TEE=d.TEE AND
d1.UNIT_DOSE_USE=d.UNIT_DOSE_USE)
FROM
P_CLAIMQTY_OUTSTANDING(CURRENT_DATE - 120, NULL, NULL) p
JOIN MDDB_DRUG d
ON d.PRODUCTID = p.PRODUCTID
GROUP BY
p.ACCOUNTID, p.SRVPROVID, p.NDC9, d.GPI, d.TEE, d.UNIT_DOSE_USE
HAVING
SUM(p.QTY) > 0

This returns an error that the ( after the stored procedure name is
unexpected, and if I try to prepare the SQL statement in order to check
for syntax errors, I get back "PLAN ERROR!" and the server crashes.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Monday, April 10, 2006 11:17 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Requesting plan crashes FB 1.5.3

Depending on how the query which hits a stored procedure is formed, it
will either crash FB 1.5.3, the returned plan will contain gibberish, or
sometimes I'll just get back "PLAN ERROR!".
I have heard about problems with getting back invalid plan text. I
don't have a small test case, just our large database. I can remove the
confidential data and FTP it to an FB developer if needed.

Thanks, Rick DeBay


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links