SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle XE htp-package limitations?

658048Oct 5 2009 — edited Oct 7 2009

Hello,
I'm developing a web application on my laptop Windows XP pro, Oracle XE 10 + apache + mod_owa. I had some serious issues with htp.p -calls, I'd keep getting this error message, no matter how small I made the htp.p -arguments

Error 6502 calling procedure:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.HTP", line 1536
....

I then started to wonder about this, and so I copied my packages to another machine (Windows server 2003, Oracle 10g, apache + mod_owa), compiled them and my error disappeared !
Now is this some sort of limitation in Oracle XE, or what?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2009

Added on Oct 5 2009

17 comments

1,965 views