[DB-SIG] Insert for Oracledb

[Hiren Hindoccha]

On Fri, 21 Nov 1997, Victoria White wrote:

> Please can someone send me a working code sample of how they
> successfully used the oracledb module (from Digital Creations) to insert

Wouldn't the following work - 

stmt = """
INSERT INTO people VALUES ('%s','%s','%s','%s','%s','%s','%s','%s',%s); """

sqlstmt = stmt % (your_tuple)
cur.executesql(sqlstmt)


I've used the above to do the inserts. Is the problem that you don't
want to specify the data types that should be inserted into the table  ? 


Hiren
--------------------------------------------------------
"!sgub evah t'nseod CP sihT ?sgub naem ayaddahW"


_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________