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..