changed from ms sql to oracle

From: mike <skyxx_at_263.net>
Date: Tue, 12 Sep 2000 13:55:18 +0800
Message-ID: <8pkgbg$oab$1@news.cz.js.cn>

hi all:

   i created a procedure in mssql like below:

---

      create procedure getData
        ( @tblName varchar(20)
         )
      as
        Begin
          declare @sql varchar(100)
          select @sql= 'select * from ' + @tblName
          exec(@sql)

    End

---

now i want to change it to oracle what should i do? Received on Tue Sep 12 2000 - 00:55:18 CDT