Skip to Content
0
Former Member
Apr 22, 2009 at 06:21 PM

Stored procedures issue in universe BOXIR3.0

25 Views

unable to insert two tables one at a time in a universe using below stored procedure. The database is Oracle. The same stored procedure is getting inserted in to the universe, when the database is SQL Server 2000. Is it any known issues!!

CREATE PROCEDURE sp_getcustomer_2results

@location nvarchar(10)

AS

SELECT CustomerID as KEYID, Contactname as Lname

FROM CUSTOMERS

WHERE ADDRESS like @location

SELECT fax as fax, region as region

FROM CUSTOMERs

Thanks for all your help in advance!

Thanks & Regards,

Manasa.

Edited by: Manasa Reddy on Apr 22, 2009 8:49 PM