Insert blob data from one db to other db in oracle
Murthy Jn
murthy919 at gmail.com
Tue Feb 28 08:02:43 EST 2017
On Tuesday, February 28, 2017 at 6:30:54 PM UTC+5:30, Murthy Jn wrote:
> I have the table structure in one db is number,photo,date,name.
> the same structure is there in other database in other machine.
>
> I want to insert table1 data from db1 into table2 in db2 using python script.
>
> Some one could please help me in this.. I have tried like below.
>
> for fetching rows
> db connection
> cur=db.cursor()
> SqlFth="select no,photo,date,name from table1;
> cur.execute(SqlFth)
> res=cur.fetchall()
> rows=[]
> for row in res:
> no,photo,date,name=row
> rows.append(row)
> n1= row[0]
> f1=row[1]
> d1=row[1]
> na1=row[2]
>
> for inserting to other db:
>
> SqlStr="insert into test (no,photo,date,name) values(:n1,:f1,:d1,:na1)"
> print SqlStr
> cur.executemany(SqlStr,rows)
> res1=cur.fetchone()
> cur.execute("commit")
>
> Please help me in this...
while executing I am getting following error ::
insert into test (no,photo,date,name) values(:n1,:f1,:d1,:na1)
Variable_TypeByValue(): unhandled data type cx_Oracle.LOB
More information about the Python-list
mailing list