RE: Code Conversion from MSSQL into Oracle

-----Original Message-----
From: VIVEK_SHARMA [mailto:VIVEK_SHARMA@infosys.com]
Sent: Thursday, December 11, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Code Conversion from MSSQL into Oracle

 

Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle?

 

SAMPLE :-

--------

DECLARE @entity_id char(32), @branch_id char(9)

 

DECLARE  cur_temp_GEMT CURSOR FOR select

         branch_id,entity_id from GEMT where other_party_name='' and entity_type='D'

 

OPEN cur_temp_GEMT       

        

FETCH NEXT FROM cur_temp_GEMT INTO

      @branch_id,@entity_id

     

WHILE @@FETCH_STATUS = 0

 

BEGIN

 

 

UPDATE GEMT SET other_party_name=(SELECT name from GEAT where branch_id =@branch_id and entity_id=@entity_id and  addr_type='1' and entity_type='D') where entity_id=@entity_id and branch_id = @branch_id

 

FETCH NEXT FROM cur_temp_GEMT INTO

      @branch_id,

      @entity_id

 

 

END

 

CLOSE cur_temp_GEMT

DEALLOCATE cur_temp_GEMT

 

 

DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged.
It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail,
please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use,
save, disclose, distribute, copy, print or relay this e-mail. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Shiva Maran
  INET: Shivam_at_talisma.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).