Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Stored procedures issue in universe BOXIR3.0

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

Not what you were looking for? View more on this topic or Ask a question