Subject Select from SP in a view
Author Regina Phandu
Hi,

I need to select a value form store procedure in a view. I have the following
sql statement:

CREATE VIEW vPA
(
category,
description,
CatDetID,
pointdescr,
typepa,
)
AS
SELECT FIRST 100
a.category,
a.description,
b.CatDetID,
b.pointdescr,
sp_small_vPA.SupervisorF
FROM sp_small_vPA, evalcattab a INNER JOIN
evalcatdet b ON a.category = b.category
;

I have an error on sp_small_vPA.
The procedure itself is working. I can select the value from the store
procedure.

Can anybody help?

TIA,
Regina