Ad Widget

Collapse

data.sql and oracle

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bibi23
    Member
    • Oct 2005
    • 64

    #1

    data.sql and oracle

    Hi,

    there are some problem in the data.sql file with oracle.

    Some insert line contain < or >. the & sign fail when inserting in oracle database.
    for exemple:
    "insert into help_items values (3,'ftp<...."

    Other line escape ' et \ in wrong way.
    with oracle ' is escaped like this: '' and \ like this: \\

    Thanks
  • kereszt
    Junior Member
    • Jun 2006
    • 1

    #2
    start data.sql with this line:

    set define off

    However, I still have lots of problems with unterminated strings and too long lines...

    Comment

    Working...