Using a temp table in a stored procedure fails when calling stored procedure via JDBC #2206 Closed StijnVdd opened on Aug 29, 2023 ...

Description I am getting an error declaring a variable referencing a table column type in an Oracle nested procedure. I'm using dbeaver Community 23.0.3.202304240616.

TABLE=<'> ORACLE-table <'>; specifies the name of the ORACLE table or ORACLE view on which the access descriptor is based. This statement is required. The ORACLE-table-name argument can be up to 30 ...

This looks like the sort of table that oracle might throw in automatically if you use Application Builder, but I haven't touched that for this user at all, even though I did play with it under the ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR ...