CrazyEngineers Logo

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

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

  • Manish Goyal
    Manish Goyal
    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

You are reading an archived discussion.

Related Posts

Final year project in embeded systems: coin sensors

hi everyone, i am doing my final year and now i am ready to final project in embedded systems.. i wanted to details regarding coin sensors . my aim is...

lcd to touch screen..?

hello frds, can i convert my lcd monitor to touch screen..?

Computaional Fluid Dynamics

Im working on a project in CFD.My aim is to model and analyse the flow of fluid through the pipes.Im currently using Gambit software for modelling the pipes and tanks.I...

ABS in two wheelers?

hi friends, i dont know why there is no antilock breaking system(ABS) in two wheelers. send me ur suggestions.

Find the output for the following code (4)

Sir / Madam, My question is Find the output for the following code #define one 0 #ifdef one printf("one is defined "); #ifndef one printf("one is not defined "); Advance...