Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle - ORA-01840: input value not long enough for date format

NodjusJun 27 2018 — edited Jun 27 2018

Hello,

I am on ApEx 18.1.0.00.45

I am on ApEx 18.1.0.00.45
I'm trying to run a query to insert data into my database via a form I created but I'm facing an error : ORA-01840: input value not long enough for date format

Here is the query I'm trying to execute :

INSERT INTO GSLIGNE.CONTRAT(STATUT, GROUPE_EVALUATION, RESEAU, DEBUT, FIN, POP_RESPONSABILITE, ANNE_RECENSEMENT, GROUPE_EQUITE, ENTITE_IDENTITE)

VALUES(:P54_STATUT_MILIEU, :P54_GROUPE_EVALUATION, :P54_RESEAUX, :P54_DEBUT, :P54_FIN, :P54_POP_RESPONSABILITE, :P54_ANNE_RECENSEMENT, :P54_GROUPE_EQUITE, :P54_IDENTITE);

Can someone help me please ? :-)

Many thanks

Michel

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2018
Added on Jun 27 2018
#apex-discussions
1 comment
2,424 views