Skip to Main Content

SQL & PL/SQL

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!

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

KrishnaPrasadNov 15 2008 — edited Nov 15 2008
Hi
i am writing a view with 2 cols, both r of number datatype.
when i am trying to fetch values from view its working fine.

I have a search query where i am joinining view to table with some conditions and adding condition for one of the view column.
then its giving me error :
java.sql.SQLException: ORA-12801: error signaled in parallel query server P020
ORA-01840: input value not long enough for date format

No where i am using Date datatype.
Help me out please.
Krishna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2008
Added on Nov 15 2008
2 comments
711 views