Bob Pawley wrote:
> I have the following cursor that gives me an error near open.
>
> Can someone please tell me what I am doing wrong??
> DECLARE
> procgraphic cursor for select process_id from p_id.p_id,
> processes_count where p_id.p_id.p_id_id = processes_count.p_id_id;
> begin
>
> Open procgraphic ;
There is no OPEN, you just FETCH
> Fetch first from procgraphic into process_id;
--
Richard Huxton
Archonet Ltd