Dear All,
I already create this SP in SQL Server 2000.
CREATE PROCEDURE XYZ
@INPUT NVARCHAR(255)
AS
DECLARE @X NVARCHAR(255)
SET @X = 'SELECT * FROM NORTHWIND.DBO.PRODUCTS ' + @INPUT
EXEC SP_EXECUTESQL @X
GO
To execute the SP, I run this statement:
EXEC XYZ 'WHERE PRODUCTID = 1'
Now I want to write an identical SP in Oracle. Does anybody know how to write it in Oracle?