On Thursday 29 May 2003 10:58 am, David Collie (itndac) wrote:
> I am assuming that this is caused by the 'varray' return from Oracle
> (think it is using nested tables) because when I remove this column, all
> is fine
You can use subscript notation to access varray elements, something like the
below.
I guess there's also a function to return the length of the array[*], so you
should be able to write a procedure to call to do the dirty for you.
DECLARE
TYPE Staff IS TABLE OF Employee;
staffer Employee;
FUNCTION new_hires (hiredate DATE) RETURN Staff IS
BEGIN ... END;
BEGIN
staffer := new_hires('10-NOV-98')(5);
...
END;
[*] If not, you'll need another proc to return the first NULL element.
--
Tom C
"Land of the free, home of the brave... you have to be brave to live there and
enjoy the freedoms"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
