Re: Cursor

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