Re: changed from ms sql to oracle

From: nomenclature <tonal_at_pestilence.net>
Date: Wed, 13 Sep 2000 12:23:47 +0100
Message-ID: <39BF63C3.29CBB321@pestilence.net>

mike wrote:
>
> 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?

You'll need to use Oracle provided packages for dynamic SQL. Simple to use once you've read the userguide. Read the PL/SQL one first though... Received on Wed Sep 13 2000 - 06:23:47 CDT