Avatar of chalie001
chalie001
 asked on

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

hi am geting error in this function ORA-06502: PL/SQL: numeric or value error: character to number conversion error
conversionerror.sql
DatabasesOracle Database

Avatar of undefined
Last Comment
chalie001

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Helena Marková

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
chalie001

ASKER
i also what to pass a number in this function like 1254455
Helena Marková

You can add input parameter to your function like this:
CREATE OR REPLACE FUNCTION GEN_CURRENT_SIN (vsInput VARCHAR2,x_numInput NUMBER) ...
chalie001

ASKER
i use he function
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck