ORA-06502 Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can someone please help me? I am trying to run an Oracle application
through Internet Explorer. I get an error message when I create a new
Expense report:

"ORA-06502: PL/SQL: numeric or value error: character string buffer too
small occurred in AP_WEB_START_PKG.strep_parent with parameters
(SuppressWizard=N) while performing the following operation: Get profile
options and prompt"

This error occurs only on one PC and will work on other PCs. Not sure if
spyware is causing the issue, but I'm pretty sure that I removed all known
spyware. I've also tried re-installing IE with no luck.

I am running Windows XP SP1 with IE6 SP1.

Thanks,

Rich
 
On the problem machine, in IE, click Tools Option from the toolbar, choose
Internet Options, then from the General tab, in the Temporary Internet
files block, choose Settings. In the Settings window, under where it says
Check for newer versions of stored pages: check either Every visit to the
page OR Every time you start Internet Explorer. Be sure to say OK at each
window to save your changes.
 
Unfortunately this did not work. If anyone else has any ideas, I would
really appreciate it.

Thanks,

Rich
 
....
Unfortunately this did not work. If anyone else has any ideas, I would
really appreciate it.
Click to expand...


If a bad page was already cached that might not have been enough.
Try pressing Ctrl-F5 (for a cacheless refresh) or clear your TIF
to eliminate the cache from the symptom description.

Otherwise what you should do is get traces of the same request on both
machines and compare them. E.g. that way you could find out which field
the data is coming from which is too long--equally likely is that there could be
a missing separator which is resulting in two fields being concatenated into
one overly long field. Etc.

Alternatively ask your host support for help in interpreting
the error message. They may know of additional diagnostics
you could invoke instead on the server side.


Good luck

Robert Aldwinckle[/QUOTE]
 
Back
Top