I'd like to create an in-memory array variable that can be used in my PL/SQL code. I can't find any collections in Oracle PL/SQL that uses pure memory, they all seem to be associated with …

Jun 22, 2021 · PL/SQL doesn't like that. In the for loop : You are trying to loop over the type and not the array for i in 1..array.count loop it should be : for i in 1..arry.count loop Generally …

Starting with Oracle Database Release 18c, any PL/SQL value can be provided by an expression (for example for a record or for an associative array) like a constructor provides an abstract …

Jun 23, 2021 · I want to run the select ... where number in &array in DB B (Oracle). DB A is only used to provide the list to the variable "array" I cannot join DB A & B with a DB link.

Aug 23, 2010 · There is an ARRAY type in PL/SQL; it's called a VARRAY, which is a 1-indexed array with a fixed upper bound of elements. What you're using is an associative array, which is …

Feb 6, 2012 · A two dimension array mathematically is just a mapping (X, Y) -> VALUE. So, how about creating a temporary table with 3 columns: X, Y, VALUE in PL/SQL ?

Sep 20, 2016 · I'm trying to pass an array of (varchar) data into an Oracle procedure. The Oracle procedure would be either called from SQL*Plus or from another PL/SQL procedure like so: …

Jan 29, 2013 · As Oracle has a built-in collection type called VARRAY, v_array is a bad name for a nested table type. It could confuse a stupid person.

Jul 10, 2012 · As the documentation states, EXISTS() tests for the existence of a numbered entry in a collection. That is, array.exists(3) asserts that the third element of array is populated. …

2 It is possible to use a PL/SQL-defined nested table type (as opposed to a SQL-defined nested table type) indirectly in an IN clause of a SELECT statement in a PL/SQL package. You must …