RE: Triggers - Value Passing

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Tue, 22 Mar 2005 02:23:52 -0800 (PST)
Message-ID: <20050322102352.96336.qmail@web52907.mail.yahoo.com>

I manage to found an example that show how this Returning clause work. The bind variable works in iSQL* PLUS.

INSERT INTO employees

      (employee_id, last_name, email, hire_date, job_id, salary)

   VALUES
   (employees_seq.nextval, 'Doe',
'john.doe_at_oracle.com',

       SYSDATE, 'SH_CLERK', 2400)
   RETURNING salary*12, job_id INTO :bnd1, :bnd2;

My question , If this statement put inside a trigger . Then how would a trigger pass the returning value to my application ?

JKean

• Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
  > Hi
  >
  > >How would i know what id number get's created ?
  > Izzit
  > >by issueing seq_emp.currval ? If i issued this
  > select
  > >seq_emp.currval from my trigger how can i pass this
  > >value to my web application ?
  >
  > Give a look to the RETURNING clause in the SQL
  > Reference.
  >
  >
  > HTH
  > Chris
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  

  ---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 22 2005 - 05:27:27 CST