how to declare an array variable in a pl/sql procedure?

pushpa1989

pushpa1989

@pushpa1989-Z0zODt Oct 22, 2024
Please checkout and tell whether the code given below is correct or not
create procedure p5(reg number,n number)
is i1 number;
e1 number;
nam varchar2(20);
tot number;
j number;
l number;
k number;
r1 number;
m number;
st varchar2(10);
avg float;
type t1 IS VARRAY(10) OF number;
t t1;

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

  • Manish Goyal

    Manish Goyal

    @manish-r2Hoep Jan 4, 2010

    create procedure p5(reg number,n number)
    i1 number;
    e1 number;
    nam varchar2(20);
    tot number;
    j number;
    l number;
    k number;
    r1 number;
    m number;
    st varchar2(10);
    avg float;
    type t1 IS VARRAY(10) of number(3);
    t t1;
    I think this is correct code