I'm receiving the following error when I try to execute a Dynamic SQL Stored Procedure SmartObject within BlackPearl. The same SMO executes successfully via the tester app using the same data.
Error:
SmartObject Event xml validation against schema failed: The element cannot contain text. Content model is empty.
Stored Procedure:
ALTER PROCEDURE [dbo].[getLoanLookupByLoanNumber]
(@LoanNumber int = -1
,@LoanNumberReturn int OUTPUT
,@LoanId int OUTPUT
,@CompanyName varchar(50) OUTPUT
,@FirstName varchar(25) OUTPUT
,@LastName varchar(25) OUTPUT
,@TaxIdSSN varchar(20) OUTPUT)
AS
BEGIN
SET NOCOUNT ON;
SELECT TOP 1
@LoanNumberReturn = [vwLoanLookup].[LoanNumber],
@LoanId = [vwLoanLookup].[LoanId],
@CompanyName = [vwLoanLookup].[CompanyName],
@FirstName = [vwLoanLookup].[FirstName],
@LastName = [vwLoanLookup].[LastName],
@TaxIdSSN = [vwLoanLookup].[TaxIdSSN]
FROM [dbo].[vwLoanLookup] with(nolock)
WHERE [vwLoanLookup].[LoanNumber] = @LoanNumber
END
Any ideas?