SQL & PL/SQL

I want a PL/sql procedure to select the data from the column dynamically into a variable .

My friend suggested its not possible in PL/sql ,its only possible in sql .

What i want is when i execute the PL/sql procedure the a_1 must get the value of the data in the table,i do not want to use execute immediate in pl/sql.

I create a table A

create table A (a1 number,a2 number,a3 number);

insert into a values (1,2,3);

then i create a procedure

create or replace
procedure test_a (var IN number)
as
a_1 number;
i number;
z varchar2(5);

begin
if var=1
then
i:=1;
elsif var = 2
then
i:=2;
z:='A2';
end if;
SELECT 'a'||i into a_1 from a;
end;

Edited by: user536416 on May 13, 2010 4:03 AM