Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EJB & Primary Keys
Did u declare something special in your table in order to make "returning" working ?
-- Jérôme CARPENE Stagiaire Adésium Clermont-Ferrand "Yong" <yhuang_at_indigopool.com> a écrit dans le message news: 8mbug0$43m$1_at_news.sinet.slb.com...Received on Fri Aug 04 2000 - 00:00:00 CDT
> This reminds me of the new Oracle clause for INSERT, RETURNING. But I
don't
> know EJB so the following may only work in PL/SQL:
>
> declare hisid number(10);
> begin
> insert into emps (emp_name) values ('John Doe') returning emp_id into
hisid;
> end;
> /