Re: Keep having ORA-01000 Error Message

Ahmed Baraka wrote:
> I have a procedure which define a cursor in the declaration section. Then in
> execution section, it uses FOR LOOP to open, fetch and close records
> retreived by the cursor. The cursor loops through 147 employees and does
> processing on every employee.
>
> Every time I run the procedure, I get the frustrating error message
> ORA-01000. I set OPEN_CURSOR to 5000 and still I have the same error.
>
> Please any guideline to overcome this error. It really caused big delay in
> my project.
>
>
post your code

-- 

Regards,
Frank van Bortel