inserting data into oracle db using python

Thread Rating:

Thread Modes

inserting data into oracle db using python

nilamo
Last Thursdayist
Super Moderators

Posts: 3,458

Threads: 101

Joined: Sep 2016

Reputation: 143

#10

May-22-2017, 08:08 PM

(May-22-2017, 03:34 PM)sahilsiddharth Wrote: cursor.execute("""INSERT INTO TELM VALUES(%s)""", (a))

That's not a tuple, it's just a. Because it's a single item, you need to add a comma to force a single-element tuple, like so:

cursor.execute("""insert into telm values (%s)""", (a, ))

Find

Messages In This Thread

RE: inserting data into oracle db using python - by nilamo - May-22-2017, 08:08 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Inserting Python Buttons into KV Files	edand19941	3	486	Feb-19-2025, 07:44 PM Last Post: buran
	Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules.	DivyaKumar	3	8,189	Oct-01-2024, 03:32 PM Last Post: Alex_Kirpichny
	Load data in Oracle	muzokh	0	1,183	Mar-08-2024, 11:19 PM Last Post: muzokh
	python script for inserting rows into hbase table	lravikumarvsp	7	8,658	Mar-24-2023, 04:44 AM Last Post: parth_botadara
	Basic SQL query using Py: Inserting or querying sqlite3 database not returning data	marlonbown	3	3,036	Nov-08-2022, 07:16 PM Last Post: marlonbown
	Migrating data from oracle into postgres	python_student	1	3,325	Feb-10-2022, 09:16 PM Last Post: buran
	Encrypting Oracle Passwords / Python Library for That?	bmccollum	1	3,512	Jun-11-2021, 07:59 PM Last Post: Larz60+
	Load data from One oracle Table to Multiple tables	amy83	1	2,274	Dec-02-2020, 01:57 AM Last Post: Larz60+
	Calling Oracle REST SQL from Python	johnjacob	2	2,695	Nov-05-2020, 04:19 AM Last Post: johnjacob
	Python to Oracle Conn Issue	chvsnarayana	2	54,809	Sep-06-2020, 04:33 PM Last Post: Larz60+

Users browsing this thread: 1 Guest(s)