| Different behaviour [message #188736] |
Mon, 21 August 2006 06:35  |
salmanucit
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 (10.1.2.0.2) and also upgraded the mod_plsql in my backend DB which is 9.2.0.6 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
PARAMETERS :
===========
business_entity_in:
LizLink
application_in:
ccOrderTracking
userid_in:
dfdfdfdfdfdf
password_in:
email_num:
*******************************************
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?
regards
|
|
|
|
| Re: Different behaviour [message #189494 is a reply to message #188736] |
Thu, 24 August 2006 18:12  |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
