I have created pre-insert Trigger at master % detail blocks.
in the master & details tables i have WHO columns in the back-end.
BEGIN
SELECT JVG_HEADER_ID_SEQ.nextval INTO :XX_JVG_CATALOG_HEADER.CAT_HEADER_ID FROM DUAL;
Fnd_Standard.set_who;
END;
Error : ORA-01830: date format picture ends before converting entire input string
How to over come this problem.
Regards
Siva
ORA-01830: date format picture ends before convert
-
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
Hi Siva,
Error: ORA-01830: date format picture ends before converting entire input string
Cause: You tried to enter a date value, but the date entered did not match the date format.
Action: The options to resolve this Oracle error are:
This error can occur when you try to enter a date value without using the to_date function.
In Oracle, the default date format is generally DD-MON-YYYY. If you try to enter a date value that does not comply with this format, you need to use the to_date function.
For example, if you tried to execute the following SQL statement:
INSERT INTO supplier
VALUES
(1, 'IBM', '13-DEC-2004 6:56 PM');
You would receive the following error message:
ORA-01830: date format picture ends before converting entire input string
To correct this error, you can use the to_date function as follows:
INSERT INTO supplier
VALUES
(1, 'IBM', to_date('13-DEC-2004 6:56 PM', 'dd-mon-yyyy hh:mi PM'));
Error: ORA-01830: date format picture ends before converting entire input string
Cause: You tried to enter a date value, but the date entered did not match the date format.
Action: The options to resolve this Oracle error are:
This error can occur when you try to enter a date value without using the to_date function.
In Oracle, the default date format is generally DD-MON-YYYY. If you try to enter a date value that does not comply with this format, you need to use the to_date function.
For example, if you tried to execute the following SQL statement:
INSERT INTO supplier
VALUES
(1, 'IBM', '13-DEC-2004 6:56 PM');
You would receive the following error message:
ORA-01830: date format picture ends before converting entire input string
To correct this error, you can use the to_date function as follows:
INSERT INTO supplier
VALUES
(1, 'IBM', to_date('13-DEC-2004 6:56 PM', 'dd-mon-yyyy hh:mi PM'));
Hi Siva Sankar,
I'm using the Fnd_Standard.set_who; in the pre-insert procedure.
When ever i click in Form Front end by clicking SAVE button ,
This is how i'm getting the Error.
In forms where will be the Fnd_Standard.set_who; will be available.If u have idea can u please explane me in detail.
if possible u can mail me @ sivaprasad_14@yahoo.com
I'm using the Fnd_Standard.set_who; in the pre-insert procedure.
When ever i click in Form Front end by clicking SAVE button ,
This is how i'm getting the Error.
In forms where will be the Fnd_Standard.set_who; will be available.If u have idea can u please explane me in detail.
if possible u can mail me @ sivaprasad_14@yahoo.com
Who is online
Users browsing this forum: No registered users and 5 guests