We help IT Professionals succeed at work.

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

chalie001
chalie001 asked
on
518 Views
Last Modified: 2017-03-07
hi am geting error in this function ORA-06502: PL/SQL: numeric or value error: character to number conversion error
conversionerror.sql
Comment
Watch Question

programmer-analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
i also what to pass a number in this function like 1254455
Helena Markováprogrammer-analyst
CERTIFIED EXPERT

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

Author

Commented:
i use he function