Re: problem in checking Result Set -please help me... URGENT..

[ajai chaganti]

 hi,

my collegue able to execute the  same procedure  and check the results the sql navigator. but this problem is appearing

only in toad. Please clarify me how to resolve the issue.

 :) Have a Great Day  .........

Thanks 'n' Regards

Ajaibabu Chaganti





----- Original Message ----
From: Jeff Smith <jeff.smith@...>
To: "toad@..." <toad@...>
Sent: Friday, July 11, 2008 18:14:15
Subject: RE: [toad] problem in checking Result Set  -please help me... URGENT..


Talk to your DBA.  This is a problem with your database, not
with Toad.
 
From:toad@yahoogroups. com [mailto:toad@ yahoogroups. com] On Behalf Of ajai
chaganti
Sent: Friday, July 11, 2008 8:37 AM
To: toad@yahoogroups. com
Subject: [toad] problem in checking Result Set -please help me...
URGENT..
 
Hi ,
 
when i tried to execute a stored procedure.i' m getting the
following error message.
 
the stored procedure reads three input variables and gives
result in a result set.
 
2.1 Date          : Fri, 11 Jul
2008 17:32:24 +0500
  2.2 Address       : 006624BB
  2.3 Module Name   : toad.exe - (Toad for
Oracle)
  2.4 Module Version: 9.6.1.1
  2.5 Type          :
EOraError
  2.6 Message       : ORA-04031: unable
to allocate 4032 bytes of shared memory ("shared pool","oracle/aurora/ rdbms/DbmsJavaSY S","joxlod:
in ehe","ioc_allocate_ pal")
ORA-06512
          : at "SYS.DBMS_JAVA", line 0
ORA-06512           : at line 1
             
      .
  2.7 ID          
 : 28B7
  2.8 Count         : 1
  2.9 Status        : New
  2.10 Note         :
 
 
 

Thanks 'n' Regards

Ajaibabu Chaganti
 

Send instant messages to your online friends http://uk.messenger .yahoo.com  

Send instant messages to your online friends http://uk.messenger.yahoo.com 

[Jeff Smith-7]

Is your colleague using the same user account to login and execute the procedure?

What anonymous block is SQL Nav generating to do the execution as opposed to Toad’s?

From: toad@... [mailto:toad@...] On Behalf Of ajai chaganti
Sent: Friday, July 11, 2008 8:49 AM
To: toad@...
Subject: Re: [toad] problem in checking Result Set -please help me... URGENT..


 hi,

my collegue able to execute the  same procedure  and check the results the sql navigator. but this problem is appearing

only in toad. Please clarify me how to resolve the issue.



 :) Have a Great Day  .........

Thanks 'n' Regards

Ajaibabu Chaganti

----- Original Message ----
From: Jeff Smith <jeff.smith@...>
To: "toad@..." <toad@...>
Sent: Friday, July 11, 2008 18:14:15
Subject: RE: [toad] problem in checking Result Set -please help me... URGENT..
Talk to your DBA.  This is a problem with your database, not with Toad.

From: toad@yahoogroups. com [mailto:toad@ yahoogroups. com] On Behalf Of ajai chaganti
Sent: Friday, July 11, 2008 8:37 AM
To: toad@yahoogroups. com
Subject: [toad] problem in checking Result Set -please help me... URGENT..

Hi ,

when i tried to execute a stored procedure.i' m getting the following error message.

the stored procedure reads three input variables and gives result in a result set.

2.1 Date          : Fri, 11 Jul 2008 17:32:24 +0500
  2.2 Address       : 006624BB
  2.3 Module Name   : toad.exe - (Toad for Oracle)
  2.4 Module Version: 9.6.1.1
  2.5 Type          : EOraError
  2.6 Message       : ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","oracle/aurora/ rdbms/DbmsJavaSY S","joxlod: in ehe","ioc_allocate_ pal")
ORA-06512           : at "SYS.DBMS_JAVA", line 0
ORA-06512           : at line 1
                     .
  2.7 ID            : 28B7
  2.8 Count         : 1
  2.9 Status        : New
  2.10 Note         :





Thanks 'n' Regards

Ajaibabu Chaganti


Send instant messages to your online friends http://uk.messenger .yahoo.com

Send instant messages to your online friends http://uk.messenger.yahoo.com


 
 

[Peter van Rijn]

Your colleague is just a lucky guy/gal.
The error plainly tells you the *server* (i.e. the Oracle instance) has
not enough memory available to serve your request.
This would probably mean that the shared_pool_size has to be extended.
The mere fact that your colleague is able to run it without problems
does not mean the instance isn't running low on memory, it just means
that at *that* moment there was enough memory.

regards,
Peter


ajai chaganti schreef:

>
>
>
>  hi,
>
> my collegue able to execute the  same procedure  and check the results
> the sql navigator. but this problem is appearing
>
> only in toad. Please clarify me how to resolve the issue.
>
>
>  :) Have a Great Day  .........
>
> Thanks 'n' Regards
>
> */Ajaibabu Chaganti
> /*
>
>
>
> ----- Original Message ----
> From: Jeff Smith <jeff.smith@...>
> To: "toad@..." <toad@...>
> Sent: Friday, July 11, 2008 18:14:15
> Subject: RE: [toad] problem in checking Result Set -please help me...
> URGENT..
>
> Talk to your DBA.  This is a problem with your database, not with Toad.
>
>  
>
> *From:* toad@yahoogroups. com [mailto:toad@ yahoogroups. com] *On Behalf
> Of *ajai chaganti
> *Sent:* Friday, July 11, 2008 8:37 AM
> *To:* toad@yahoogroups. com
> *Subject:* [toad] problem in checking Result Set -please help me... URGENT..
>
>  
>
> Hi ,
>
>  
>
> when i tried to execute a stored procedure.i' m getting the following
> error message.
>
>  
>
> the stored procedure reads three input variables and gives result in a
> result set.
>
>  
>
> 2.1 Date          : Fri, 11 Jul 2008 17:32:24 +0500
>
>   2.2 Address       : 006624BB
>
>   2.3 Module Name   : toad.exe - (Toad for Oracle)
>
>   2.4 Module Version: 9.6.1.1
>
>   2.5 Type          : EOraError
>
>   2.6 Message       : ORA-04031: unable to allocate 4032 bytes of shared
> memory ("shared pool","oracle/aurora/ rdbms/DbmsJavaSY S","joxlod: in
> ehe","ioc_allocate_ pal")
>
> ORA-06512           : at "SYS.DBMS_JAVA", line 0
>
> ORA-06512           : at line 1
>
>                      .
>
>   2.7 ID            : 28B7
>
>   2.8 Count         : 1
>
>   2.9 Status        : New
>
>   2.10 Note         :
>
>  
>
>  
>
>  
>
> Thanks 'n' Regards
>
> /*Ajaibabu Chaganti*/
>
>  
>
>
> Send instant messages to your online friends http://uk.messenger .yahoo.com
>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>