WindmillWWindmill
Powered by
hdoussiH
Windmill•12mo ago•
3 replies
hdoussi

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 ?
WindmillJoin
3,362Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

Passing workspace variable as items in Select input
Meow the MagnificentMMeow the Magnificent / help
3y ago
[Windmill App] How to use Display: Inline-Block or Flex
brian_gtbBbrian_gtb / help
14mo ago
how to accept oauth resource as script input
BertPBBertP / help
4mo ago
How can we use inline script to get source for a download button?
My_Name_Is_ShefMMy_Name_Is_Shef / help
2y ago