Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I use array in stored procedure

Re: Can I use array in stored procedure

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 17 Feb 2003 12:15:02 +0300
Message-ID: <b2q9a5$llk$1@babylon.agtel.net>


Sure. There are PL/SQL arrays (TYPE array_type IS TABLE OF <TYPE> INDEX BY BINARY_INTEGER), nested table types (those without INDEX BY clause, declared as SQL types with CREATE TYPE) and VARRAYs. Read about them in SQL Reference, PL/SQL User's Guide and Application Developer's Guide (Object-Relational Features.) Also research bulk binding (FORALL and BULK COLLECT.)

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"antoine gefflot" <agefflot_at_ipsis.fr> wrote in message news:b2q7c3$4cg$1_at_s1.read.news.oleane.net...

> I have to store many data (like point for example) and I would like to know
> if there is data type like array to call a stored procedure only once rather
> than X times where X is the number of data.
>
> Thanks
>
> Antoine
>
>
Received on Mon Feb 17 2003 - 03:15:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US