Is there any drawback (except allowing the value or array to grow too large) to setting the max integer size of a VARCHAR or VARRAY to a value significantly larger than actually necessary (or setting it to the max size allowed)?
...
I've got a PL/SQL VArray that I'm filling with a BULK COLLECT query like this:
SELECT id
BULK COLLECT INTO myarray
FROM aTable
Now I'd like to pass a slice of this collection into another collection, something like this:
newarray := myarray(2..5)
This should pass the elements 2,3,4 and 5 from myarray to newarray.
I could write a l...
Hi,
I am trying to write a small program which has to store and retrieve values from database. The database is object relational.
Here're the DDL statements :
create or replace type Guy as object (name varchar(80), address varchar(80), dateOfBirth date)
create or replace type KnownLanguages as varray(10) of varchar(80)
create table ...
Hello All
I am encountering an issue when I am trying to load a large result set using a range query in Oracle 10g.
When I try a smaller range (1 to 100), it works but when I try a larger range(1 and 1000),
I get the following error "ORA-22814: attribute or element value is larger than specified in type" error. I have a basic UDT (Po...
Slightly broad question here, but here goes
I'm trying to call an Oracle stored procedure, which returns a VARRAY which is of constructed from a ROWTYPE on one of my tables. For simplicity, lets say this table looks like the following :
MY_TABLE
ID VALUE
-----------
1 John
2 Dave
so I will call a SP that returns the followin...