hdoussi•4w ago

Inline OracleDB . How to use input variable as Oracle table name?

If I try the following query into InlineDB Oracle function I get the error message «{"name":"ExecutionErr","message":"execution error:\nError: OCI Error: ORA-00903: invalid table name» -- :name1 (text) -- :name2 (text) -- :table_name (text) INSERT INTO :table_name (COLUMN1, COLUMN2) VALUES (:name1, :name2);
Is that possible to define a variable as input for the table name and if so, what is the correct format ?

3 Replies

rubenf•4w ago

not at the moment but soon yes

hdoussiOP•4w ago

so alternative for now would be to use a Python script which would have the «insert into ....» instead of inline oracledb right ?

rubenf•4w ago

yes

Inline OracleDB . How to use input variable as Oracle table name?

Did you find this page helpful?