|
ORA-00925: missing INTO keyword
|
|||
---|---|---|---|
#18+
Please help me figure out why the error is returned? (cx_Oracle.DatabaseError) ORA-00925: missing INTO keyword [SQL: INSERT INTO my_table (type_id, contact_id) VALUES (:type_id, :contact_id) RETURNING my_table.id, my_table.contact_id] [parameters: [{'type_id': 'binding_card_ma', 'contact_id': 'party_id_4'}, {'type_id': 'binding_card_ma', 'contact_id': 'party_id_5'}]] I use sqlalchemy, python ins = f'INSERT INTO {my_table} (type_id, contact_id) ' \ f'VALUES (:type_id, :contact_id) ' \ f'RETURNING {my_table}.id, {my_table}.contact_id' session.execute(ins, value_list) ... |
|||
:
Нравится:
Не нравится:
|
|||
11.04.2021, 20:48 |
|
ORA-00925: missing INTO keyword
|
|||
---|---|---|---|
#18+
e.burenina, When use RETURNING, must use RETURNING INTO see: SQL reference -> INSERT -> returning clause p.s. use SRC tag ... |
|||
:
Нравится:
Не нравится:
|
|||
11.04.2021, 23:05 |
|
ORA-00925: missing INTO keyword
|
|||
---|---|---|---|
#18+
Vadim Lejnin, please clarify how to use the SRC tag? ... |
|||
:
Нравится:
Не нравится:
|
|||
12.04.2021, 10:42 |
|
ORA-00925: missing INTO keyword
|
|||
---|---|---|---|
#18+
[ SRC PLSQL ] INSERT INTO {my_table} (type_id, contact_id) VALUES (:type_id, :contact_id) RETURNING {my_table}.id, {my_table}.contact_id [ / SRC ] Код: plsql 1. 2. 3.
... |
|||
:
Нравится:
Не нравится:
|
|||
12.04.2021, 10:45 |
|
|
start [/forum/topic.php?fid=52&msg=40061494&tid=1880293]: |
0ms |
get settings: |
9ms |
get forum list: |
13ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
140ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
42ms |
get tp. blocked users: |
2ms |
others: | 262ms |
total: | 488ms |
0 / 0 |