Home » SQL & PL/SQL » SQL & PL/SQL » Procedures failing
Procedures failing [message #20810] Fri, 21 June 2002 13:08 Go to next message
smat
Messages: 4
Registered: February 2002
Junior Member
Hi,
Is it possible that a procedure that runs successfully on a table with 500 rows of data runs successfully, but fails when the same table has 100000 or more rows of data? Why?
Re: Procedures failing [message #20817 is a reply to message #20810] Sun, 23 June 2002 17:12 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
I think this might cause by some setting in Oracle Server (parameter).

Maybe server doesn't have enough memory or something else. I think you need to tune the cause on server. please check the return error by server. Hope this is heping.
Previous Topic: autocommit
Next Topic: retrieve data from clob column
Goto Forum:
  


Current Time: Mon Jun 03 07:02:19 CDT 2024