I normally don't comment on spelling because god knows that mine
sucks ... but when someone offers a code example and says that it
doesn't work when it is clear that it couldnt even compile because of
the spelling errors in it I have to wonder what the actual question
is...
Sorry if that seems harsh but there is no way that this code compiled
and you claim that "it doesnt work". To say that I am unsurprised is
an understatement.
I know that this wasn't your question but please do not include code
examples unless they are real (or are clearly pseudocode) and there is
no way that either of the code examples you gave could have compiled.
On Oct 23, 12:57 am, somy <[EMAIL PROTECTED]> wrote:
> Got it guys, below is the code....
>
> Create or relplace funcion (pvar t_rec)
> return pak.cursor
> as
> pkddetails pak.cursor;
> Mempid varchar2(1000);
> begin
> memp:='select * from emp where empid IN (';
> for i in 1..pvar.count loop
> mempid:=mempid||''''||pvar (i)||''''||',' ;
> end loop;
> mempid:= substr(mempid,1,(length(mempid) -1));
> mempid:= mempid || ')';
> open pkddetails for
> mempid;
> return pkddetail ;
> end;
> /
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
