Posts

Showing posts from April, 2008

ORA-06502: PL/SQL: numeric or value error

The docs note this on the ORA-06502 error: ORA-06502: PL/SQL: numeric or value error string Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2). Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints. More Information by Anantha: This error mainly occurs due to one of the following: 1. If you assign NULL value to a NOT NULL field. 2. If you assign number which is larger than the precision of the field. 3. If you assign character values greater than the field width. Simply stating the value being assigned is not a valid value which can be assigned to the string/numeric field. For example: declare test varchar2(1); begin test := 'I am here'; end; The above block gives the error: ORA-06502: ...

ORA-04031: Unable to allocate %s bytes of shared memory

ORA-04031: Unable to allocate %s bytes of shared memory   Solutions:   alter system set shared_pool_size=100M; -- size you have to decide based alter system set large_pool_size=100M ;    -- on sga_max_size   Oracle limits the increase of size up to SGA_MAX_SIZE parameter defined in the initialization parameter file. SGA memory can not be increase beyond SGA_MAX_SIZE. If SGA_MAX_SIZE parameter is not enough for increasing the memory of dynamic parameters, you will get a ORA-00384 error. In this case either you have to increase the SGA_MAX_SIZE parameter or decrease the memory of dynamic parameter.   alter system set db_cache_size=135m;   alter system set db_cache_size=135m   *   ERROR at line 1:   ORA-02097: parameter cannot be modified because specified value is invalid   ORA-00384: Insufficient memory to grow cache     alter system set   SGA_MAX_SIZE=150M scope=spfile;   System altered. ...

Query to find out queries running in database

To find out which queries are running in database, login as SYS and issue the following query:   SELECT a.USERNAME, a.STATUS, b.sql_text FROM V$SESSION a INNER JOIN V$SQLAREA b ON a.SQL_ADDRESS= b.ADDRESS;   V$SESSION view lists session information for each current session.   To see field-wise description for V$SESSION follow the link below: V$SESSION V$SQLAREA lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution. To see field-wise description for V$SQLAREA follow the link below: V$SQLAREA

FRM-40502: ORACLE error: unable to read list of values

This is what Oracle has to say about this error: --- FRM-40502: ORACLE error: unable to read list of values. Cause:   A fatal error occurred while trying to read a list of values. Action:   Contact your DBA or an Oracle support representative. Level:   >25 Type:   Error --- I had not encountered this error till recent times. But it was today I had encountered this error. I was scratching my head as to what caused this error. I was working with a form with 6i release, converted to 10g. In that while clicking F9 for LOV in one of the fields, I encountered this error. I started debugging the form, starting from Field, LOV, Record Group. There were no problems at first sight. I copied the SQL query from the record group and ran it in SQL*Plus, there was no problems. The query was using some bind variables from inside the form. I had modified these fields with values. I then tried to run exactly the same where clause of the query (I com...