PL/SQL (MOSC)

MOSC Banner

ARRAY in PL/SQL

edited Jun 18, 2010 12:51AM in PL/SQL (MOSC) 2 commentsAnswered
Hello,
I have a problem with ARRAY using.
Could You help me, how i can put data into array in PL/SQL block?

Please send me any example of this.

My code is:
DECLARE
   cur_m24_stf1      m24_stf%ROWTYPE;
   cur_m24_stf2      m24_stf%ROWTYPE;
   v_counter         NUMBER(10) := 1;
   v_counter_all     NUMBER(10) := 0;
   CURSOR cur_vyber01
       IS
         SELECT stf_seq, stf_date, stf_table, NVL(account, '0') as acct, priority
           FROM m24_stf
          WHERE stf_seq > -1
       ORDER BY priority, stf_seq;
   TYPE a_m24_stf IS TABLE OF m24_stf%ROWTYPE;
   s_m24StfOraTab a_m24_stf;
BEGIN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center