Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EJB & Primary Keys

Re: EJB & Primary Keys

From: Jerome Carpene <jerome.carpene_at_aliso.com>
Date: 2000/08/04
Message-ID: <8me7ki$gds$2@wanadoo.fr>#1/1

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

> 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;
> /
Received on Fri Aug 04 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US