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

    pushpa1989

    pushpa1989

    @pushpa1989-Z0zODt
    Updated: Oct 22, 2024
    Views: 993
    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;
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies
  • Manish Goyal

    MemberJan 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
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register