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...