Help me in PHP- Oracle

Discussion in 'PHP' started by balasun, Apr 20, 2009.

0
  1. #1
    Hello all,

    I need to excute the oracle query like Below:
    "begin
    myfriends_data.get_multi_rows_details:)StartDate,
    :EndDate,
    :filed3,
    :filed4,
    );
    end";

    I give the StartDate value as '01/01/2009';

    But when i execute the query, i got the error like Below:

    ORA-01843: not a valid month
    ORA-06512: at line 2

    Pls help me how to solve the problem.

    Thanks,
     
    balasun, Apr 20, 2009 IP
  2. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    #2
    check with the default format of date in your orcale installation
     
    kishore415, Apr 20, 2009 IP