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
conversionerror.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can add input parameter to your function like this:
CREATE OR REPLACE FUNCTION GEN_CURRENT_SIN (vsInput VARCHAR2,x_numInput NUMBER) ...
CREATE OR REPLACE FUNCTION GEN_CURRENT_SIN (vsInput VARCHAR2,x_numInput NUMBER) ...
ASKER
i use he function
ASKER