Skip to main content

Posts

Showing posts from 2010

Sporadic 'ORA-01001 Invalid cursor' error in Oracle 11g

According to the Oracle documentation,
" The ORA-01001 error occurs when:
A host language program call gave an invalid cursor for use
The value of the MAXOPENCURSORS option in the precompiler command was too small

You can fix the ORA-01001 error by: Checking your problematic call statement for any issuesSpecifying a correct LDA area or open the cursor as requiredIncreasing the MAXOPENCURSORS option value before precompiling As a note, the ORA-01001 error does not exist in Oracle 10g"

After debugging for almost a day following the above hints, I came to realise there is nothing wrong with my PL/SQL or with the configuration settings.

Sporadic "ORA-01001: invalid cursor" error occurs in Oracle 11g if there are RAM memory issues on the server.

If the same client call works once and fails the other minute with this error, you can check the server for memory issues before debugging further.

Windows Sleep command

I have a really long bat file where I need to introduce delay between subsequent commands. But there is no sleep command in DOS. There is an workaround for this, we can use ping command to emulate sleep.

Usage ping 1.1.1.1 -n 1 -w 10000

switch -n specifies number of echo request to be sent.
switch -w specifies number of milliseconds to wait for each reply.