pl/sql function

Question

Hi there!..

 

 

 

   I have a doubt friends on returning a table from a function in oracle11g i tried to do that as

1. created a table (parent)of type object

 

create or replace type Pitchtype as object
(
id number(4),
name varchar2(20)
);
 

2. created a table(child) of type parent.(netsted table) with the fields that we need to have from function.

 

create or replace type Pitchtypenested as table of Pitchtype;

 

3. and finally created a function

 

 create or replace function Pitchreturntable return Pitchtypenested is
Results Pitchtypenested := Pitchtypenested();
begin
select id,name into Results from pitchhello;
return(Results);
end Pitchreturntable;

 

table pitchhello having id and name fields..

 

it gives me pl/sql:ora-00947: not enough values error.. i could'nt have been come to find the place making error...

pls friends help me..