Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
11.04.2021, 20:48
|
|||
---|---|---|---|
|
|||
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, 23:05
|
|||
---|---|---|---|
|
|||
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 ... |
|||
:
Нравится:
Не нравится:
|
|||
|
12.04.2021, 10:42
|
|||
---|---|---|---|
|
|||
ORA-00925: missing INTO keyword |
|||
#18+
Vadim Lejnin, please clarify how to use the SRC tag? ... |
|||
:
Нравится:
Не нравится:
|
|||
|
12.04.2021, 10:45
|
|||
---|---|---|---|
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.
... |
|||
:
Нравится:
Не нравится:
|
|||
|
|
start [/forum/topic.php?fid=52&tablet=1&tid=1880293]: |
0ms |
get settings: |
9ms |
get forum list: |
12ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
136ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
37ms |
get tp. blocked users: |
1ms |
others: | 10ms |
total: | 223ms |
0 / 0 |