Character to number conversion error:

From: Zahid Khan <zahid_at_cc.gatech.edu>
Date: Mon, 09 Aug 1999 13:02:27 -0400
Message-ID: <37AF09A3.920B4BAA_at_cc.gatech.edu>


[Quoted] I am using WebDB on Oracle8i to make a data entry form. When the user fills in the data on a webpage and hits the submit button,

[Quoted] a PL/SQL procedure is called and the data is supposed to be stored in the appropiate tables. however, I get this error message:

ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1

I don't know how to interpret this error message. Where is the error? On

[Quoted] line one of my PL/SQL code? or somewhere else?

Here's my PL/SQL code:

create or replace procedure data_entry ( p_cmpd_id in varchar2,

p_cmpd_name in varchar2,
p_cmpd_formula in varchar2,
p_ca_number in number,
p_purity in number,
p_molecular_wt in number,
p_crit_temp in number,
p_crit_press in number,
p_crit_vol in number,
p_norm_bp in number,
p_melt_pt in number,
p_lmv in number )

begin

  • inserting data into cmpd table insert into fpri_admin.cmpd values ( p_cmpd_id, p_cmpd_name, p_cmpd_formula, p_ca_number, p_purity, p_molecular_wt, p_crit_temp, p_crit_press, p_crit_vol, p_norm_bp, p_melt_pt, p_lmv); end data_entry;

Can someone tell me why I get this error?

TIA
Zahid Khan Received on Mon Aug 09 1999 - 19:02:27 CEST

Original text of this message