PL/SQL :: Native Dynamic Sql

find the below scripts .

drop table test_arp;

create table test_arp
(
first_name varchar2(1000),
last_name varchar2(1000)
);

[Code]....

when i select the above table ,i will be getting the result as shown

first_name , last_name
CONTROL    PANEL
ORACLE       SEA
                 WILLIAMS
RAHUL        KUMAR

I need  to make a table which will be having the following data and structure

col1            col2          col3
CONTROL    ORACLE    RAHUL

.i.e , depending on the number of not null values in the first column (first_name), i will be creating a table dynamically ,which is going to have as many columns as the number of values and the naming convention is col1,col2,col...........

I designed the below procedure to CREATE OR REPLACE PROCEDURE ARP
AS
C NUMBER:=1;

BEGIN
FOR I IN (SELECT FIRST_NAME FROM TEST_ARP WHERE FIRST_NAME IS NOT NULL)
LOOP
IF C=1 THEN

[Code]...

But when i execute this code , i get the below error

ORA-00984: column not allowed here
ORA-06512: at "ARP", line 17
ORA-06512: at line 1