Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Apr 2012
    Location
    St. Louis, MO
    Posts
    985
    Thanks
    7
    Thanked 101 Times in 101 Posts

    Unhappy ORACLE: Missing Comma

    Hello, everyone.

    Could someone please help me find which comma is missing from this ORACLE SQL statement??

    Code:
    INSERT into WEBSHOP.WIDGET_ANNOUNCEMENT(
        item_id,
        webshop_app_id,
        announcement_title,
        announcement_desc,
        to_date(announcement_date,'YYYY-MM-DD'),
        announcement_order,
        to_date(announcement_start_display,'YYYY-MM-DD'),
        to_date(announcement_end_display,'YYYY-MM-DD'),
        announcement_link
        ) 
    VALUES(
        'AB393197-C00C-6589-8A939E57951B57D0',
        'AB393198-C10C-2913-02392E637FB9956B',
        'Title for Announcement 01',
        'Description for Announcement 01',
        to_date('2012-07-27','YYYY-MM-DD'),
        4,
        to_date('2012-08-01','YYYY-MM-DD'),
        to_date('2012-08-08','YYYY-MM-DD'),
        'http://www.domain.com/AB39319D-DCDF-ABB2-FE67C4D05CBB9944'
        );
    I keep getting ORACLE:00917 Missing comma error message. I cannot see which comma is missing, and the database is keeping that part a secret.
    Last edited by WolfShade; 07-31-2012 at 09:13 PM.
    ^_^

    If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
    *
    The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".

  • #2
    Regular Coder
    Join Date
    Apr 2012
    Location
    St. Louis, MO
    Posts
    985
    Thanks
    7
    Thanked 101 Times in 101 Posts
    Have I mentioned how much I detest Oracle?

    Fixed the above issue, and then promptly created another. Now I'm getting ORA-00911:Invalid character. I'm looking at all the output (similar to what I pasted, above) and I'm not seeing any invalid characters.

    EDIT: Adding the new SQL statement, hoping someone sees what I'm not.

    Code:
    INSERT into WEBSHOP.WIDGET_ANNOUNCEMENT(
        item_id,
        webshop_app_id,
        announcement_title,
        announcement_desc,
        announcement_date,
        announcement_order,
        announcement_start_display,
        announcement_end_display,
        announcement_link
        ) 
    VALUES(
        'B18B69B2-0E60-BFB3-96B379CCE45C8D91',
        'B18B69B3-BDE7-10B3-A1AE4829204D66F6',
        'Title for Announcement 01',
        'Description for Announcement 01',
        to_date('2012-07-27 00:00:00','YYYY-MM-DD HH24:MI:SS'),
        4,
        to_date('2012-08-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),
        to_date('2012-08-08 00:00:00','YYYY-MM-DD HH24:MI:SS'),
        'http://www.domain.com/B18B69B6-E114-ACF2-F69D1CA900827518'
        );
    Last edited by WolfShade; 07-31-2012 at 08:55 PM.
    ^_^

    If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
    *
    The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".

  • #3
    Regular Coder
    Join Date
    Apr 2012
    Location
    St. Louis, MO
    Posts
    985
    Thanks
    7
    Thanked 101 Times in 101 Posts
    I hate Oracle. The "invalid character" was the semi-colon at the end.
    ^_^

    If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
    *
    The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •