Re: [cx-oracle-users] trouble with insert

[<wa...@li...>]

Andrew Replogle wrote:

>         cursor.execute("""
>             INSERT INTO CONTENT_STYLE (CONTENT_STYLE_ID, NAME, DESCRIPTION, THEME, CLIENT, DELETED)
>             VALUES (:content_id, ':vizstylename', ':themedesc', ':themename', ':vizstylename', 0)"
> "",
>             content_id = nextval, themename = sys.argv[4], vizstylename = sys.argv[5], themedesc = sys.argv[6])

Replacing

  VALUES (:content_id, ':vizstylename', ':themedesc', ':themename', 
':vizstylename', 0)

with

  VALUES (:content_id, :vizstylename, :themedesc, :themename, 
:vizstylename, 0)

should fix your problem.

HTH,
    Walter Dörwald