Forum Discussion

soptim_vond's avatar
soptim_vond
Frequent Visitor
7 years ago

Is it possible to include multiple SQL-Statements in one query (ORACLE)?

Hi folks,   usually, working with an oracle database in a standard SQL-editor multiple sql-statements can be entered in one query separated by a semicolon. However, when I try to do that in Power B...
Need Help
soptim_vond's avatar
soptim_vond
Frequent Visitor
7 years ago

Hi Pradeep,

 

I´m not sure I get the part about the oracle connector, but here´s my m code from the advanced editor:

 

let

Quelle = Oracle.Database("se.trunk", [Query="
DELETE
FROM PMS_OWNER.VB_LIM_TB_REPORT_TEMPDATA RTDB
WHERE rtdb.RTDB_CLIENT = SYS$UTIL.machine || SYS$UTIL.osuser;
insert into lim_owner.tb_report_tempdata
(rtdb_client, rtdb_item, rtdb_value_number, rtdb_value_string, rtdb_value_datum, rtdb_produkt)
values
(SYS$UTIL.machine || SYS$UTIL.osuser, 'MND', 62, NULL, NULL, 'PMS')
", HierarchicalNavigation=true])

in
Quelle

 

(I know using transactional SQL is not recommended... :))

Regards,

 

Nico

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi soptim_vond Anonymous ,

This is not working for me.

let
Source = Oracle.Database("hyd1225d.india", [Query="select * from APG0_BANK_ACCOUNTS;select * from APG0_CHECKS",HierarchicalNavigation=true])
in
Source

 

It's throwing error like DataSource.Error: Oracle: ORA-00933: SQL command not properly ended.

can you please help me.

Thanks,

Rajyalakshmi.