Error running dlt pipeline to send loaded table query result to s3!
Traceback (most recent call last):
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.12/site-packages/oracledb/cursor.py", line 710, in execute
    impl.execute(self)
  File "src/oracledb/impl/thin/cursor.pyx", line 196, in oracledb.thin_impl.ThinCursorImpl.execute
  File "src/oracledb/impl/thin/protocol.pyx", line 440, in oracledb.thin_impl.Protocol._process_single_message
  File "src/oracledb/impl/thin/protocol.pyx", line 441, in oracledb.thin_impl.Protocol._process_single_message
  File "src/oracledb/impl/thin/protocol.pyx", line 433, in oracledb.thin_impl.Protocol._process_message
  File "src/oracledb/impl/thin/messages.pyx", line 74, in oracledb.thin_impl.Message._check_and_raise_exception
oracledb.exceptions.DatabaseError: ORA-01704: string literal too long
Help: https://docs.oracle.com/error-help/db/ora-01704/

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.12/site-packages/dlt/extract/pipe_iterator.py", line 274, in _get_source_item
    pipe_item = next(gen)
                ^^^^^^^^^
  File "/worker/shared/task_handlers/run_pipeline/dlt_sources.py", line 1300, in enrichment_resource
    yield from _enrich_from_parquet(
  File "/worker/shared/task_handlers/run_pipeline/dlt_sources.py", line 1174, in _enrich_from_parquet
    query_result = conn.execute(text(cte_query), bind_params)
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1422, in execute
    return meth(
           ^^^^^
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 514, in _execute_on_connection
    return connection._execute_clauseelement(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1644, in _execute_clauseelement
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1850, in _execute_context
    return self._exec_single_context(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1990, in _exec_single_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2357, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.12/site-packages/oracledb/cursor.py", line 710, in execute
    impl.execute(self)
  File "src/oracledb/impl/thin/cursor.pyx", line 196, in oracledb.thin_impl.ThinCursorImpl.execute
  File "src/oracledb/impl/thin/protocol.pyx", line 440, in oracledb.thin_impl.Protocol._process_single_message
  File "src/oracledb/impl/thin/protocol.pyx", line 441, in oracledb.thin_impl.Protocol._process_single_message
  File "src/oracledb/impl/thin/protocol.pyx", line 433, in oracledb.thin_impl.Protocol._process_message
  File "src/oracledb/impl/thin/messages.pyx", line 74, in oracledb.thin_impl.Message._check_and_raise_exception
sqlalchemy.exc.DatabaseError: (oracledb.exceptions.DatabaseError) ORA-01704: string literal too long
Help: https://docs.oracle.com/error-help/db/ora-01704/
[SQL: WITH pipeline_test_function AS (
    SELECT charge_item_id
    FROM JSON_TABLE('[{"charge_item_id": 0}, {"charge_item_id": 1000}, {"charge_item_id": 1005}, {"charge_item_id": 1010}, {"charge_item_id": 1015}, {"charge_item_id": 1020}, {"charge_item_id": 1025}, {"charge_item_id": 1030}, {"charge_item_id": 1036}, {"charge_item_id": 1042}, {"charge_item_id": 1048}, {"charge_item_id": 1054}, {"charge_item_id": 1060}, {"charge_item_id": 1065}, {"charge_item_id": 1070}, {"charge_item_id": 1076}, {"charge_item_id": 1082}, {"charge_item_id": 1087}, {"charge_item_id": 1093}, {"charge_item_id": 1099}, {"charge_item_id": 1104}, {"charge_item_id": 1109}, {"charge_item_id": 1114}, {"charge_item_id": 1120}, {"charge_item_id": 1125}, {"charge_item_id": 1131}, {"charge_item_id": 1136}, {"charge_item_id": 1141}, {"charge_item_id": 1146}, {"charge_item_id": 1151}, {"charge_item_id": 1156}, {"charge_item_id": 1161}, {"charge_item_id": 1166}, {"charge_item_id": 1171}, {"charge_item_id": 1177}, {"charge_item_id": 1183}, {"charge_item_id": 1188}, {"charge_item_id": 1193}, {"charge_item_id": 1199}, {"charge_item_id": 1205}, {"charge_item_id": 1211}, {"charge_item_id": 1216}, {"charge_item_id": 1222}, {"charge_item_id": 1227}, {"charge_item_id": 1232}, {"charge_item_id": 1237}, {"charge_item_id": 1242}, {"charge_item_id": 1248}, {"charge_item_id": 1253}, {"charge_item_id": 1258}, {"charge_item_id": 1263}, {"charge_item_id": 1268}, {"charge_item_id": 1274}, {"charge_item_id": 1279}, {"charge_item_id": 1285}, {"charge_item_id": 1291}, {"charge_item_id": 1297}, {"charge_item_id": 1303}, {"charge_item_id": 1308}, {"charge_item_id": 1313}, {"charge_item_id": 1319}, {"charge_item_id": 1325}, {"charge_item_id": 1330}, {"charge_item_id": 1335}, {"charge_item_id": 1340}, {"charge_item_id": 1346}, {"charge_item_id": 1351}, {"charge_item_id": 1356}, {"charge_item_id": 1361}, {"charge_item_id": 1367}, {"charge_item_id": 1372}, {"charge_item_id": 1377}, {"charge_item_id": 1382}, {"charge_item_id": 1387}, {"charge_item_id": 1392}, {"charge_item_id": 1398}, {"charge_item_id": 1403}, {"charge_item_id": 1409}, {"charge_item_id": 1415}, {"charge_item_id": 1421}, {"charge_item_id": 1426}, {"charge_item_id": 1431}, {"charge_item_id": 1436}, {"charge_item_id": 1442}, {"charge_item_id": 1447}, {"charge_item_id": 1452}, {"charge_item_id": 1458}, {"charge_item_id": 1464}, {"charge_item_id": 1470}, {"charge_item_id": 1476}, {"charge_item_id": 1481}, {"charge_item_id": 1486}, {"charge_item_id": 1492}, {"charge_item_id": 1498}, {"charge_item_id": 1500}, {"charge_item_id": 1504}, {"charge_item_id": 1508}, {"charge_item_id": 1514}, {"charge_item_id": 1519}, {"charge_item_id": 1525}, {"charge_item_id": 1530}, {"charge_item_id": 1535}, {"charge_item_id": 1539}, {"charge_item_id": 1542}, {"charge_item_id": 1546}, {"charge_item_id": 1551}, {"charge_item_id": 1553}, {"charge_item_id": 1557}, {"charge_item_id": 1562}, {"charge_item_id": 1567}, {"charge_item_id": 1572}, {"charge_item_id": 1576}, {"charge_item_id": 1581}, {"charge_item_id": 1586}, {"charge_item_id": 1591}, {"charge_item_id": 1595}, {"charge_item_id": 1597}, {"charge_item_id": 1602}, {"charge_item_id": 1604}, {"charge_item_id": 1610}, {"charge_item_id": 1614}, {"charge_item_id": 1618}, {"charge_item_id": 1623}, {"charge_item_id": 1629}, {"charge_item_id": 1635}, {"charge_item_id": 1640}, {"charge_item_id": 1642}, {"charge_item_id": 1648}, {"charge_item_id": 1652}, {"charge_item_id": 1658}, {"charge_item_id": 1663}, {"charge_item_id": 1665}, {"charge_item_id": 1669}, {"charge_item_id": 1673}, {"charge_item_id": 1677}, {"charge_item_id": 1683}, {"charge_item_id": 1688}, {"charge_item_id": 1693}, {"charge_item_id": 1697}, {"charge_item_id": 1701}, {"charge_item_id": 1706}, {"charge_item_id": 1710}, {"charge_item_id": 1716}, {"charge_item_id": 1721}, {"charge_item_id": 1724}, {"charge_item_id": 1729}, {"charge_item_id": 1731}, {"charge_item_id": 1735}, {"charge_item_id": 1740}, {"charge_item_id": 1746}, {"charge_item_id": 1750}, {"charge_item_id": 1754}, {"charge_item_id": 1760}, {"charge_item_id": 1765}, {"charge_item_id": 1769}, {"charge_item_id": 1773}, {"charge_item_id": 1777}, {"charge_item_id": 1781}, {"charge_item_id": 1786}, {"charge_item_id": 1788}, {"charge_item_id": 1792}, {"charge_item_id": 1794}, {"charge_item_id": 1799}, {"charge_item_id": 1803}, {"charge_item_id": 1807}, {"charge_item_id": 1811}, {"charge_item_id": 1813}, {"charge_item_id": 1815}, {"charge_item_id": 1820}, {"charge_item_id": 1826}, {"charge_item_id": 1831}, {"charge_item_id": 1835}, {"charge_item_id": 1839}, {"charge_item_id": 1844}, {"charge_item_id": 1848}, {"charge_item_id": 1853}, {"charge_item_id": 1858}, {"charge_item_id": 1862}, {"charge_item_id": 1864}, {"charge_item_id": 1869}, {"charge_item_id": 1871}, {"charge_item_id": 1876}, {"charge_item_id": 1882}, {"charge_item_id": 1887}, {"charge_item_id": 1892}, {"charge_item_id": 1897}, {"charge_item_id": 1901}, {"charge_item_id": 1903}, {"charge_item_id": 1907}, {"charge_item_id": 1911}, {"charge_item_id": 1915}, {"charge_item_id": 1921}, {"charge_item_id": 1923}, {"charge_item_id": 1928}, {"charge_item_id": 1932}, {"charge_item_id": 1938}, {"charge_item_id": 1943}, {"charge_item_id": 1949}, {"charge_item_id": 1953}, {"charge_item_id": 1955}, {"charge_item_id": 1959}, {"charge_item_id": 1964}, {"charge_item_id": 1970}, {"charge_item_id": 1976}, {"charge_item_id": 1980}, {"charge_item_id": 1982}, {"charge_item_id": 1986}, {"charge_item_id": 1992}, {"charge_item_id": 1996}, {"charge_item_id": 2002}, {"charge_item_id": 2006}, {"charge_item_id": 2008}, {"charge_item_id": 2012}, {"charge_item_id": 2018}, {"charge_item_id": 2023}, {"charge_item_id": 2025}, {"charge_item_id": 2030}, {"charge_item_id": 2033}, {"charge_item_id": 2038}, {"charge_item_id": 2042}, {"charge_item_id": 2047}, {"charge_item_id": 2051}, {"charge_item_id": 2056}, {"charge_item_id": 2060}, {"charge_item_id": 2065}, {"charge_item_id": 2071}, {"charge_item_id": 2076}, {"charge_item_id": 2082}, {"charge_item_id": 2084}, {"charge_item_id": 2089}, {"charge_item_id": 2094}, {"charge_item_id": 2096}, {"charge_item_id": 2102}, {"charge_item_id": 2106}, {"charge_item_id": 2110}, {"charge_item_id": 2115}, {"charge_item_id": 2119}, {"charge_item_id": 2123}, {"charge_item_id": 2129}, {"charge_item_id": 2132}, {"charge_item_id": 2134}, {"charge_item_id": 2140}, {"charge_item_id": 2146}, {"charge_item_id": 2150}, {"charge_item_id": 2155}, {"charge_item_id": 2160}, {"charge_item_id": 2166}, {"charge_item_id": 2168}, {"charge_item_id": 2173}, {"charge_item_id": 2178}, {"charge_item_id": 2180}, {"charge_item_id": 2185}, {"charge_item_id": 2187}, {"charge_item_id": 2192}, {"charge_item_id": 2198}, {"charge_item_id": 2200}, {"charge_item_id": 2205}, {"charge_item_id": 2209}, {"charge_item_id": 2215}, {"charge_item_id": 2219}, {"charge_item_id": 2221}, {"charge_item_id": 2225}, {"charge_item_id": 2230}, {"charge_item_id": 2232}, {"charge_item_id": 2238}, {"charge_item_id": 2244}, {"charge_item_id": 2249}, {"charge_item_id": 2254}, {"charge_item_id": 2258}, {"charge_item_id": 2263}, {"charge_item_id": 2267}, {"charge_item_id": 2273}, {"charge_item_id": 2275}, {"charge_item_id": 2279}, {"charge_item_id": 2283}, {"charge_item_id": 2288}, {"charge_item_id": 2294}, {"charge_item_id": 2299}, {"charge_item_id": 2303}, {"charge_item_id": 2308}, {"charge_item_id": 2310}, {"charge_item_id": 2314}, {"charge_item_id": 2318}, {"charge_item_id": 2320}, {"charge_item_id": 2324}, {"charge_item_id": 2326}, {"charge_item_id": 2330}, {"charge_item_id": 2336}, {"charge_item_id": 2340}, {"charge_item_id": 2346}, {"charge_item_id": 2350}, {"charge_item_id": 2355}, {"charge_item_id": 2359}, {"charge_item_id": 2364}, {"charge_item_id": 2370}, {"charge_item_id": 2373}, {"charge_item_id": 2377}, {"charge_item_id": 2381}, {"charge_item_id": 2383}, {"charge_item_id": 2387}, {"charge_item_id": 2392}, {"charge_item_id": 2398}, {"charge_item_id": 2403}, {"charge_item_id": 2407}, {"charge_item_id": 2413}, {"charge_item_id": 2417}, {"charge_item_id": 2422}, {"charge_item_id": 2427}, {"charge_item_id": 2433}, {"charge_item_id": 2436}, {"charge_item_id": 2443}, {"charge_item_id": 2449}, {"charge_item_id": 2455}, {"charge_item_id": 2460}, {"charge_item_id": 2465}, {"charge_item_id": 2470}, {"charge_item_id": 2473}, {"charge_item_id": 2479}, {"charge_item_id": 2484}, {"charge_item_id": 2487}, {"charge_item_id": 2493}, {"charge_item_id": 2499}, {"charge_item_id": 2505}, {"charge_item_id": 2510}, {"charge_item_id": 2513}, {"charge_item_id": 2515}, {"charge_item_id": 2521}, {"charge_item_id": 2526}, {"charge_item_id": 2531}, {"charge_item_id": 2537}, {"charge_item_id": 2542}, {"charge_item_id": 2548}, {"charge_item_id": 2555}, {"charge_item_id": 2560}, {"charge_item_id": 2566}, {"charge_item_id": 2572}, {"charge_item_id": 2576}, {"charge_item_id": 2580}, {"charge_item_id": 2582}, {"charge_item_id": 2588}, {"charge_item_id": 2593}, {"charge_item_id": 2600}, {"charge_item_id": 2605}, {"charge_item_id": 2610}, {"charge_item_id": 2615}, {"charge_item_id": 2622}, {"charge_item_id": 2628}, {"charge_item_id": 2633}, {"charge_item_id": 2638}, {"charge_item_id": 2644}, {"charge_item_id": 2649}, {"charge_item_id": 2655}, {"charge_item_id": 2661}, {"charge_item_id": 2666}, {"charge_item_id": 2672}, {"charge_item_id": 2678}, {"charge_item_id": 2683}, {"charge_item_id": 2688}, {"charge_item_id": 2695}, {"charge_item_id": 2699}, {"charge_item_id": 2705}, {"charge_item_id": 2710}, {"charge_item_id": 2715}, {"charge_item_id": 2719}, {"charge_item_id": 2726}, {"charge_item_id": 2733}, {"charge_item_id": 2736}, {"charge_item_id": 2741}, {"charge_item_id": 2747}, {"charge_item_id": 2752}, {"charge_item_id": 2757}, {"charge_item_id": 2763}, {"charge_item_id": 2768}, {"charge_item_id": 2775}, {"charge_item_id": 2781}, {"charge_item_id": 2786}, {"charge_item_id": 2791}, {"charge_item_id": 2797}, {"charge_item_id": 2800}, {"charge_item_id": 2805}, {"charge_item_id": 2811}, {"charge_item_id": 2816}, {"charge_item_id": 2823}, {"charge_item_id": 2827}, {"charge_item_id": 2833}, {"charge_item_id": 2836}, {"charge_item_id": 2842}, {"charge_item_id": 2847}, {"charge_item_id": 2853}, {"charge_item_id": 2859}, {"charge_item_id": 2865}, {"charge_item_id": 2870}, {"charge_item_id": 2876}, {"charge_item_id": 2883}, {"charge_item_id": 2889}, {"charge_item_id": 2896}, {"charge_item_id": 2901}, {"charge_item_id": 2906}, {"charge_item_id": 2911}, {"charge_item_id": 2914}, {"charge_item_id": 2919}, {"charge_item_id": 2925}, {"charge_item_id": 2931}, {"charge_item_id": 2937}, {"charge_item_id": 2943}, {"charge_item_id": 2949}, {"charge_item_id": 2955}, {"charge_item_id": 2961}, {"charge_item_id": 2967}, {"charge_item_id": 2972}, {"charge_item_id": 2975}, {"charge_item_id": 2978}, {"charge_item_id": 2984}, {"charge_item_id": 2989}, {"charge_item_id": 2995}, {"charge_item_id": 3001}, {"charge_item_id": 3006}, {"charge_item_id": 3013}, {"charge_item_id": 3017}, {"charge_item_id": 3020}, {"charge_item_id": 3023}, {"charge_item_id": 3026}, {"charge_item_id": 3029}, {"charge_item_id": 3034}, {"charge_item_id": 3040}, {"charge_item_id": 3045}, {"charge_item_id": 3052}, {"charge_item_id": 3057}, {"charge_item_id": 3063}, {"charge_item_id": 3069}]', '$[*]'
        COLUMNS (
            charge_item_id VARCHAR2(4000) PATH '$.charge_item_id'
        )
    )
)
select * from charge c 
join pipeline_test_function tf on tf.charge_item_id = c.charge_item_id]
(Background on this error at: https://sqlalche.me/e/20/4xp6)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/worker/shared/task_handlers/run_pipeline/pipeline.py", line 2153, in run_pipeline
    metadata, dlt_source = get_metadata(dlt_source)
                           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/worker/shared/pipelines/pipeline_utils.py", line 824, in get_metadata
    table = next(iter(obj))
            ^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.12/site-packages/dlt/common/utils.py", line 146, in flatten_list_or_items
    for items in _iter:
                 ^^^^^
dlt.extract.exceptions.ResourceExtractionError: In processing pipe getusersadmin: extraction of resource getusersadmin in generator enrichment_resource caused an exception: (oracledb.exceptions.DatabaseError) ORA-01704: string literal too long
Help: https://docs.oracle.com/error-help/db/ora-01704/
[SQL: WITH pipeline_test_function AS (
    SELECT charge_item_id
    FROM JSON_TABLE('[{"charge_item_id": 0}, {"charge_item_id": 1000}, {"charge_item_id": 1005}, {"charge_item_id": 1010}, {"charge_item_id": 1015}, {"charge_item_id": 1020}, {"charge_item_id": 1025}, {"charge_item_id": 1030}, {"charge_item_id": 1036}, {"charge_item_id": 1042}, {"charge_item_id": 1048}, {"charge_item_id": 1054}, {"charge_item_id": 1060}, {"charge_item_id": 1065}, {"charge_item_id": 1070}, {"charge_item_id": 1076}, {"charge_item_id": 1082}, {"charge_item_id": 1087}, {"charge_item_id": 1093}, {"charge_item_id": 1099}, {"charge_item_id": 1104}, {"charge_item_id": 1109}, {"charge_item_id": 1114}, {"charge_item_id": 1120}, {"charge_item_id": 1125}, {"charge_item_id": 1131}, {"charge_item_id": 1136}, {"charge_item_id": 1141}, {"charge_item_id": 1146}, {"charge_item_id": 1151}, {"charge_item_id": 1156}, {"charge_item_id": 1161}, {"charge_item_id": 1166}, {"charge_item_id": 1171}, {"charge_item_id": 1177}, {"charge_item_id": 1183}, {"charge_item_id": 1188}, {"charge_item_id": 1193}, {"charge_item_id": 1199}, {"charge_item_id": 1205}, {"charge_item_id": 1211}, {"charge_item_id": 1216}, {"charge_item_id": 1222}, {"charge_item_id": 1227}, {"charge_item_id": 1232}, {"charge_item_id": 1237}, {"charge_item_id": 1242}, {"charge_item_id": 1248}, {"charge_item_id": 1253}, {"charge_item_id": 1258}, {"charge_item_id": 1263}, {"charge_item_id": 1268}, {"charge_item_id": 1274}, {"charge_item_id": 1279}, {"charge_item_id": 1285}, {"charge_item_id": 1291}, {"charge_item_id": 1297}, {"charge_item_id": 1303}, {"charge_item_id": 1308}, {"charge_item_id": 1313}, {"charge_item_id": 1319}, {"charge_item_id": 1325}, {"charge_item_id": 1330}, {"charge_item_id": 1335}, {"charge_item_id": 1340}, {"charge_item_id": 1346}, {"charge_item_id": 1351}, {"charge_item_id": 1356}, {"charge_item_id": 1361}, {"charge_item_id": 1367}, {"charge_item_id": 1372}, {"charge_item_id": 1377}, {"charge_item_id": 1382}, {"charge_item_id": 1387}, {"charge_item_id": 1392}, {"charge_item_id": 1398}, {"charge_item_id": 1403}, {"charge_item_id": 1409}, {"charge_item_id": 1415}, {"charge_item_id": 1421}, {"charge_item_id": 1426}, {"charge_item_id": 1431}, {"charge_item_id": 1436}, {"charge_item_id": 1442}, {"charge_item_id": 1447}, {"charge_item_id": 1452}, {"charge_item_id": 1458}, {"charge_item_id": 1464}, {"charge_item_id": 1470}, {"charge_item_id": 1476}, {"charge_item_id": 1481}, {"charge_item_id": 1486}, {"charge_item_id": 1492}, {"charge_item_id": 1498}, {"charge_item_id": 1500}, {"charge_item_id": 1504}, {"charge_item_id": 1508}, {"charge_item_id": 1514}, {"charge_item_id": 1519}, {"charge_item_id": 1525}, {"charge_item_id": 1530}, {"charge_item_id": 1535}, {"charge_item_id": 1539}, {"charge_item_id": 1542}, {"charge_item_id": 1546}, {"charge_item_id": 1551}, {"charge_item_id": 1553}, {"charge_item_id": 1557}, {"charge_item_id": 1562}, {"charge_item_id": 1567}, {"charge_item_id": 1572}, {"charge_item_id": 1576}, {"charge_item_id": 1581}, {"charge_item_id": 1586}, {"charge_item_id": 1591}, {"charge_item_id": 1595}, {"charge_item_id": 1597}, {"charge_item_id": 1602}, {"charge_item_id": 1604}, {"charge_item_id": 1610}, {"charge_item_id": 1614}, {"charge_item_id": 1618}, {"charge_item_id": 1623}, {"charge_item_id": 1629}, {"charge_item_id": 1635}, {"charge_item_id": 1640}, {"charge_item_id": 1642}, {"charge_item_id": 1648}, {"charge_item_id": 1652}, {"charge_item_id": 1658}, {"charge_item_id": 1663}, {"charge_item_id": 1665}, {"charge_item_id": 1669}, {"charge_item_id": 1673}, {"charge_item_id": 1677}, {"charge_item_id": 1683}, {"charge_item_id": 1688}, {"charge_item_id": 1693}, {"charge_item_id": 1697}, {"charge_item_id": 1701}, {"charge_item_id": 1706}, {"charge_item_id": 1710}, {"charge_item_id": 1716}, {"charge_item_id": 1721}, {"charge_item_id": 1724}, {"charge_item_id": 1729}, {"charge_item_id": 1731}, {"charge_item_id": 1735}, {"charge_item_id": 1740}, {"charge_item_id": 1746}, {"charge_item_id": 1750}, {"charge_item_id": 1754}, {"charge_item_id": 1760}, {"charge_item_id": 1765}, {"charge_item_id": 1769}, {"charge_item_id": 1773}, {"charge_item_id": 1777}, {"charge_item_id": 1781}, {"charge_item_id": 1786}, {"charge_item_id": 1788}, {"charge_item_id": 1792}, {"charge_item_id": 1794}, {"charge_item_id": 1799}, {"charge_item_id": 1803}, {"charge_item_id": 1807}, {"charge_item_id": 1811}, {"charge_item_id": 1813}, {"charge_item_id": 1815}, {"charge_item_id": 1820}, {"charge_item_id": 1826}, {"charge_item_id": 1831}, {"charge_item_id": 1835}, {"charge_item_id": 1839}, {"charge_item_id": 1844}, {"charge_item_id": 1848}, {"charge_item_id": 1853}, {"charge_item_id": 1858}, {"charge_item_id": 1862}, {"charge_item_id": 1864}, {"charge_item_id": 1869}, {"charge_item_id": 1871}, {"charge_item_id": 1876}, {"charge_item_id": 1882}, {"charge_item_id": 1887}, {"charge_item_id": 1892}, {"charge_item_id": 1897}, {"charge_item_id": 1901}, {"charge_item_id": 1903}, {"charge_item_id": 1907}, {"charge_item_id": 1911}, {"charge_item_id": 1915}, {"charge_item_id": 1921}, {"charge_item_id": 1923}, {"charge_item_id": 1928}, {"charge_item_id": 1932}, {"charge_item_id": 1938}, {"charge_item_id": 1943}, {"charge_item_id": 1949}, {"charge_item_id": 1953}, {"charge_item_id": 1955}, {"charge_item_id": 1959}, {"charge_item_id": 1964}, {"charge_item_id": 1970}, {"charge_item_id": 1976}, {"charge_item_id": 1980}, {"charge_item_id": 1982}, {"charge_item_id": 1986}, {"charge_item_id": 1992}, {"charge_item_id": 1996}, {"charge_item_id": 2002}, {"charge_item_id": 2006}, {"charge_item_id": 2008}, {"charge_item_id": 2012}, {"charge_item_id": 2018}, {"charge_item_id": 2023}, {"charge_item_id": 2025}, {"charge_item_id": 2030}, {"charge_item_id": 2033}, {"charge_item_id": 2038}, {"charge_item_id": 2042}, {"charge_item_id": 2047}, {"charge_item_id": 2051}, {"charge_item_id": 2056}, {"charge_item_id": 2060}, {"charge_item_id": 2065}, {"charge_item_id": 2071}, {"charge_item_id": 2076}, {"charge_item_id": 2082}, {"charge_item_id": 2084}, {"charge_item_id": 2089}, {"charge_item_id": 2094}, {"charge_item_id": 2096}, {"charge_item_id": 2102}, {"charge_item_id": 2106}, {"charge_item_id": 2110}, {"charge_item_id": 2115}, {"charge_item_id": 2119}, {"charge_item_id": 2123}, {"charge_item_id": 2129}, {"charge_item_id": 2132}, {"charge_item_id": 2134}, {"charge_item_id": 2140}, {"charge_item_id": 2146}, {"charge_item_id": 2150}, {"charge_item_id": 2155}, {"charge_item_id": 2160}, {"charge_item_id": 2166}, {"charge_item_id": 2168}, {"charge_item_id": 2173}, {"charge_item_id": 2178}, {"charge_item_id": 2180}, {"charge_item_id": 2185}, {"charge_item_id": 2187}, {"charge_item_id": 2192}, {"charge_item_id": 2198}, {"charge_item_id": 2200}, {"charge_item_id": 2205}, {"charge_item_id": 2209}, {"charge_item_id": 2215}, {"charge_item_id": 2219}, {"charge_item_id": 2221}, {"charge_item_id": 2225}, {"charge_item_id": 2230}, {"charge_item_id": 2232}, {"charge_item_id": 2238}, {"charge_item_id": 2244}, {"charge_item_id": 2249}, {"charge_item_id": 2254}, {"charge_item_id": 2258}, {"charge_item_id": 2263}, {"charge_item_id": 2267}, {"charge_item_id": 2273}, {"charge_item_id": 2275}, {"charge_item_id": 2279}, {"charge_item_id": 2283}, {"charge_item_id": 2288}, {"charge_item_id": 2294}, {"charge_item_id": 2299}, {"charge_item_id": 2303}, {"charge_item_id": 2308}, {"charge_item_id": 2310}, {"charge_item_id": 2314}, {"charge_item_id": 2318}, {"charge_item_id": 2320}, {"charge_item_id": 2324}, {"charge_item_id": 2326}, {"charge_item_id": 2330}, {"charge_item_id": 2336}, {"charge_item_id": 2340}, {"charge_item_id": 2346}, {"charge_item_id": 2350}, {"charge_item_id": 2355}, {"charge_item_id": 2359}, {"charge_item_id": 2364}, {"charge_item_id": 2370}, {"charge_item_id": 2373}, {"charge_item_id": 2377}, {"charge_item_id": 2381}, {"charge_item_id": 2383}, {"charge_item_id": 2387}, {"charge_item_id": 2392}, {"charge_item_id": 2398}, {"charge_item_id": 2403}, {"charge_item_id": 2407}, {"charge_item_id": 2413}, {"charge_item_id": 2417}, {"charge_item_id": 2422}, {"charge_item_id": 2427}, {"charge_item_id": 2433}, {"charge_item_id": 2436}, {"charge_item_id": 2443}, {"charge_item_id": 2449}, {"charge_item_id": 2455}, {"charge_item_id": 2460}, {"charge_item_id": 2465}, {"charge_item_id": 2470}, {"charge_item_id": 2473}, {"charge_item_id": 2479}, {"charge_item_id": 2484}, {"charge_item_id": 2487}, {"charge_item_id": 2493}, {"charge_item_id": 2499}, {"charge_item_id": 2505}, {"charge_item_id": 2510}, {"charge_item_id": 2513}, {"charge_item_id": 2515}, {"charge_item_id": 2521}, {"charge_item_id": 2526}, {"charge_item_id": 2531}, {"charge_item_id": 2537}, {"charge_item_id": 2542}, {"charge_item_id": 2548}, {"charge_item_id": 2555}, {"charge_item_id": 2560}, {"charge_item_id": 2566}, {"charge_item_id": 2572}, {"charge_item_id": 2576}, {"charge_item_id": 2580}, {"charge_item_id": 2582}, {"charge_item_id": 2588}, {"charge_item_id": 2593}, {"charge_item_id": 2600}, {"charge_item_id": 2605}, {"charge_item_id": 2610}, {"charge_item_id": 2615}, {"charge_item_id": 2622}, {"charge_item_id": 2628}, {"charge_item_id": 2633}, {"charge_item_id": 2638}, {"charge_item_id": 2644}, {"charge_item_id": 2649}, {"charge_item_id": 2655}, {"charge_item_id": 2661}, {"charge_item_id": 2666}, {"charge_item_id": 2672}, {"charge_item_id": 2678}, {"charge_item_id": 2683}, {"charge_item_id": 2688}, {"charge_item_id": 2695}, {"charge_item_id": 2699}, {"charge_item_id": 2705}, {"charge_item_id": 2710}, {"charge_item_id": 2715}, {"charge_item_id": 2719}, {"charge_item_id": 2726}, {"charge_item_id": 2733}, {"charge_item_id": 2736}, {"charge_item_id": 2741}, {"charge_item_id": 2747}, {"charge_item_id": 2752}, {"charge_item_id": 2757}, {"charge_item_id": 2763}, {"charge_item_id": 2768}, {"charge_item_id": 2775}, {"charge_item_id": 2781}, {"charge_item_id": 2786}, {"charge_item_id": 2791}, {"charge_item_id": 2797}, {"charge_item_id": 2800}, {"charge_item_id": 2805}, {"charge_item_id": 2811}, {"charge_item_id": 2816}, {"charge_item_id": 2823}, {"charge_item_id": 2827}, {"charge_item_id": 2833}, {"charge_item_id": 2836}, {"charge_item_id": 2842}, {"charge_item_id": 2847}, {"charge_item_id": 2853}, {"charge_item_id": 2859}, {"charge_item_id": 2865}, {"charge_item_id": 2870}, {"charge_item_id": 2876}, {"charge_item_id": 2883}, {"charge_item_id": 2889}, {"charge_item_id": 2896}, {"charge_item_id": 2901}, {"charge_item_id": 2906}, {"charge_item_id": 2911}, {"charge_item_id": 2914}, {"charge_item_id": 2919}, {"charge_item_id": 2925}, {"charge_item_id": 2931}, {"charge_item_id": 2937}, {"charge_item_id": 2943}, {"charge_item_id": 2949}, {"charge_item_id": 2955}, {"charge_item_id": 2961}, {"charge_item_id": 2967}, {"charge_item_id": 2972}, {"charge_item_id": 2975}, {"charge_item_id": 2978}, {"charge_item_id": 2984}, {"charge_item_id": 2989}, {"charge_item_id": 2995}, {"charge_item_id": 3001}, {"charge_item_id": 3006}, {"charge_item_id": 3013}, {"charge_item_id": 3017}, {"charge_item_id": 3020}, {"charge_item_id": 3023}, {"charge_item_id": 3026}, {"charge_item_id": 3029}, {"charge_item_id": 3034}, {"charge_item_id": 3040}, {"charge_item_id": 3045}, {"charge_item_id": 3052}, {"charge_item_id": 3057}, {"charge_item_id": 3063}, {"charge_item_id": 3069}]', '$[*]'
        COLUMNS (
            charge_item_id VARCHAR2(4000) PATH '$.charge_item_id'
        )
    )
)
select * from charge c 
join pipeline_test_function tf on tf.charge_item_id = c.charge_item_id]
(Background on this error at: https://sqlalche.me/e/20/4xp6)