PL/SQL (MOSC)

MOSC Banner

Not a valid month error

edited Sep 19, 2019 5:03AM in PL/SQL (MOSC) 15 commentsAnswered

Seems that the error occurs within the function.

We are hitting some strange error on date field which causes all the existing view not working. All these views rely on a function like below. But it keeps giving "Not a valid month" error and return nothing.

Our database NLS date format is DD-MON-RR in traditional chinese.


FUNCTION test
(
n_mortgage_id IN MORTGAGE.mortgage_id%TYPE, dt_effective_date IN MORTGAGE_TERM.effect_date_from%TYPE
)
RETURN DATE
AS
c_term_date SYS_REFCURSOR;
dt_term_date MORTGAGE_TERM.effect_date_from%TYPE;
BEGIN
IF dt_effective_date = '01-JAN-00' THEN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center