RE: RETURNING clause

Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address

book...........................................................

Have A Nice Day

Gerald T. Bray
Email Administrator
Handex Environmental, Inc.
(352) 735-1800 Ext 145
E-Mail: gbray_at_handexmail.com

-----Original Message-----
Sent: Wednesday, February 27, 2002 6:13 AM To: Multiple recipients of list ORACLE-L

Hi list,
I am firing foll query from oracle forms INSERT INTO TABLE_NAME (col1,col2,..) VALUES(val1,val2,..) RETURNING ROWID INTO var_rowid.

it displays me follwoing error.

"ORA-00439:feature not enabled:RETURNING clause from this client type"

Is there any way to enable this feature from client ?

(i know that in Forms ,there is a property of
 BLOCK 'DML returning value :YES/NO' but my table is not attached to the block )

(same query works fine from sqlplus)
(Forms 6i, Orcale 8.1.6)

Any help is appreciated
Thx
Sameer

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ghadge,Sameer
  INET: Sameer_Ghadge_at_Syntelinc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may


also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babich , Sergey
  INET: SBabich_at_handexmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may


also send the HELP command for other information (like subscribing).