Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Talking Unanswered: Problem Oracle with '\' and 'and'

    Hello for all, I'm a new user and my English isn't very good .. sorry!
    I have a problem with an INSERT in Oracle, the code tha I inserd is:

    INSERT INTO Schema VALUES(schema_seq.nextval,’C:\Documents and Settings\Laura\Desktop\Tesi\File_OGaggi’)

    the error is:

    Error: ORA-00911: invalid character


    [Executed: 13/11/03 10.31.25 GMT ] [Execution: 0/ms]

    I think that the problems are '\' and the word 'and'. Someone know what can I do? Thank you, by by,

    Laura.

  2. #2
    Join Date
    Nov 2003
    Location
    Berlin, Germany
    Posts
    6

    Re: Problem Oracle with '\' and 'and'

    It seems to me that You have quoted Your string with the wrong character (´)

    You must use ' instead.

Posting Permissions

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