Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Different behaviour
Different behaviour [message #188736] Mon, 21 August 2006 06:35 Go to next message
Messages: 14
Registered: October 2005
Location: Pakistan
Junior Member
I have my application written in web tool kit and dafinately being accessed using DADs on application server 9i release 1.

I installed oracle application server 10g R2 ( and also upgraded the mod_plsql in my backend DB which is with the mod_plsql shipped with oracle 10g application server R2.

Here on some pages i see the error message like following

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 23

DAD name: dev_applink
PROCEDURE : app_login.login
URL : http://tipu.lhr.systemsltd.com:7781/pls/dev_applink/app_login.login


Why behaviour have changed, if this is an exception from DB package then why it works fine while using application from oracle 9i application server's mod_plsql ??

Second question is that another page i see the same problem but in status bar of my browser i can see the message that page is being downloaded and if i refresh the page, error goes and i see the correct result, every time i need to refresh page to see my result

any hint?

Re: Different behaviour [message #189494 is a reply to message #188736] Thu, 24 August 2006 18:12 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
difficult to tell, but a common cause is that "in" parameters of the web facing procedure should be varchar - not number or date. The data sumitted from the browser is all text. If the data represents a number or date, the conversion should be handled in the called proc where you can wrap it with error handling...

See what Line #23 is...
Previous Topic: Validate text boxes
Next Topic: item positioning - select list
Goto Forum:

Current Time: Sat Oct 22 09:27:44 CDT 2016

Total time taken to generate the page: 0.09842 seconds