#425 ORA-01830 error: Date format

2.3rc2
closed-fixed
Core (461)
5
2006-10-12
2006-09-22
Anonymous
No

I am running Squirrel version 2.3 rc1, against Oracle
9i release 2 database, oracle thin driver, on Linux.

If I run a sql select for update statement, then click
on a cell (not necessary a date cell) in the results
and edit, click on another cell, I get a warning message:

"Exception seen during check on DB. Exception was:
ORA-01830: date format picture ends before converting
entire input string"

Oracle documentation suggests this is caused by display
format incompatible with input format.

Could Squirrel query the DB for date input format, and
display it in a compatible format?

Or is there another solution?

Thanks,

sournote1@hotmail.com

Discussion

  • Rob Manning

    Rob Manning - 2006-09-22
    • assigned_to: nobody --> manningr
    • status: open --> pending
     
  • Rob Manning

    Rob Manning - 2006-09-22

    Logged In: YES
    user_id=1287991

    Hello,

    I tried selecting for update on a table with one date column
    in it and couldn't reproduce the problem. Could you give
    me exact steps and a sample table and row(s) that
    reproduce the problem reliably?

    Rob

     
  • sournote

    sournote - 2006-09-25

    Logged In: YES
    user_id=1606275

    Hi Rob.

    Here is the table creation SQL:

    CREATE TABLE RELATIONSHIP
    (
    OID NUMBER(22) not null,
    PERSON_OID1 NUMBER(22) not null,
    PERSON_OID2 NUMBER(22) not null,
    RELATIONSHIP VARCHAR2(16),
    CREATE_DATE DATE,
    MODIFIED_DATE DATE,
    CREATED_BY_PERSON_OID NUMBER(22),
    MODIFIED_BY_PERSON_OID NUMBER(22)
    );

    CREATE INDEX RELATIONSHIP_OID_PK ON RELATIONSHIP(OID);
    CREATE INDEX PERSON2OID_IDX ON RELATIONSHIP(PERSON_OID2);
    CREATE INDEX PERSON1OID_IDX ON RELATIONSHIP(PERSON_OID1);

    this will populate a row:

    INSERT INTO RELATIONSHIP
    (OID,PERSON_OID1,PERSON_OID2,RELATIONSHIP,CREATE_DATE,MODIFIED_DATE,CREATED_BY_PERSON_OID,MODIFIED_BY_PERSON_OID)
    VALUES (103,16894450,16894502,'Parent',{d
    '2005-10-21'},null,15922886,null);

    Steps to reproduce:

    Execute this SQL in Squirrel:
    select * from relationship where oid = 103 for update

    In results tab, right-click on Relationship column and
    select "Make Editable"

    Change cell contents

    Click on any other cell

    Error message appears.

    This error may also depend on some date format option set in
    the database configuration, but I don't know how to get at
    that information.

    Thanks,
    Randy

     
  • sournote

    sournote - 2006-09-25
    • status: pending --> open
     
  • Rob Manning

    Rob Manning - 2006-09-28

    Logged In: YES
    user_id=1287991

    Hello sournote1,

    Thank you for taking the time to document how the bug is
    being manifested for you. I was able to reproduce the
    problem. It looked to me to be a mismatch between
    t, ts and d escape clause identifiers and the format of
    the string value representing the date. I added a check
    to see if the value has time, date or both time & date
    components and use t, ts and d accordingly. It's now
    fixed in CVS. When the next snapshot becomes available,
    try it and let me know how it works for you.

    Rob

     
  • Rob Manning

    Rob Manning - 2006-09-28
    • labels: --> Core
    • milestone: --> 2.3rc2
    • status: open --> pending-fixed
     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending-fixed --> closed-fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks