Keep having ORA-01000 Error Message

#1

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.

#2

Ahmed Baraka wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Keep having ORA-01000 Error Message

comp.databases.oracle.tools comp.databases.oracle.tools

Keep having ORA-01000 Error Message - 02-22-2004 , 08:05 AM

Re: Keep having ORA-01000 Error Message - 02-22-2004 , 08:36 AM