1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ERROR:invalid character in Form

Discussion in 'Oracle Forms and Reports' started by saiganesh.pelluri, Mar 14, 2012.

  1. saiganesh.pelluri

    saiganesh.pelluri Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    hi
    I have developed a new form .
    After selecting a value in the list and when i click on find button it is throwing error ORA-00911 invalid character.
    Please suggest me a solution for this.

    Regards,
    Gunny
     
  2. salmankhalid

    salmankhalid Forum Advisor

    Messages:
    116
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Lahore, Pakistan
    According to the information provided there may be two cases

    You are trying to execute your query bases on special characters like

    SELECT * FROM suppliers
    WHERE supplier_name = ?;
     
    saiganesh.pelluri likes this.
  3. saiganesh.pelluri

    saiganesh.pelluri Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Thanku for your response salman as you said it contains special char
     
  4. salmankhalid

    salmankhalid Forum Advisor

    Messages:
    116
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Lahore, Pakistan
    No need to mention, is it resolved now if you found solution for using special characters in query do let me know that