ora-06502 error ?

[smacattack]

frm-40735: POST-QUERY trigger raised unhandled exception
ora-06502.

I get this error whilst actioning a query within my oracle 8i database. The forms are used via client server.
Has anybody any idea.
The oracle support says something about 'flushing the shared pool'.
How can i tell if this is what the cause is?

Please Help!!
cheers

 

[lewisp]

6502 is caused by values being too large or incorrect for the datatype. Check what values are being assigned in the post-query trigger.

If this fails to sort out the problem, check if the form was converted from forms 4.5. If so, try this:

Load your form into form builder and select Program->Find and Replace PL/SQL. In the Find What box type a ; . Type another ; into the Replace With box. Click on Replace All. When this completes, generate your form and save it. See it this solves your problem.

 

[Guest_imported]

While the size of the local variables compared
to the column sizes of the fetched variables is the
first place I would look, if your code uses PL/SQL
tables as arrays you could also be getting this error if you
try to index into an array with null as the index...

 

[Hagen]

Also you can use %Type directive to ensure that your variables can fit the values that you are retrieving from the database

EX.:

varname : Tablename.fieldname%Type;