Stored procedures in views
We are running IB 4.x on HP-UX 10.20 and Delphi applications on the
clients..
I have created a stored procedure which i want to use in a view. When I
enter the select statement of the view, it gives the expected results.
But when i say 'select * from dummyvi' the client looses connection with
the database.
Creation of the view delivers no problem.
Am I doing somthing wrong, is it a bug, is there a workaround?
Thanks,
Geert
-------------------------
create PROCEDURE wockds_id2oms_func2(B smallint, I integer)
returns
(
wocksd_oms varchar(240)
)
AS
BEGIN
wocksd_oms = "hallo";
suspend;
END &
------------------------
CREATE VIEW dummyvi (
WOCK_CKOTR_ID,
WOCKSD_OMS
) AS
SELECT
A.WOCK_CKOTR_ID,
CAST (( SELECT wocksd_oms FROM
wockds_id2oms_func2(a.wock_b_id, a.wock_ckotr_id) ) AS varchar(240))
wocksd_oms
FROM WO_CKOTR A;
-----------------------------
select * from dummyvi
