SQL-02100: Out of memory (i.e., could not allocate) Error

Hi All,
 I am developing an application in pro*c. and while executing it i am getting error "SQL-02100: Out of memory (i.e., could not allocate)"
I am getting this error when i firing a select statment


One thing to remember is that I am not getting this error consistently. i mean when i run application with one particular argument,  it is working fine but when i pass other value i am getting this error.

Pls Help me






vikram4oAsked:
Who is Participating?
 
SDuttaCommented:
What Oracle verion are you using ? Try compiling your Pro*C program with the precompiler options RELEASE_CURSOR=Y, HOLD_CURSOR=NO.
0
 
vikram4oAuthor Commented:
Thanks SDutta
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.