AnsweredAssumed Answered

create a database profile from sql stored procedure

Question asked by janetputnam700908 on Dec 1, 2017
Latest reply on Jan 18, 2018 by mplatt168095

I'm trying to create a database profile from a t-sql stored procedure. My Type is Stored Procedure Read and I clicked the Import button which opens the Database Import Wizard. Set up the connection click on Next, in the next screen I get Choose a Stored Procedure or Function. I select my stored procedure and click Next. The next screen is Choose Columns, but all I get is @RETURN_VALUE [RETURN]. My stored procedure is very simple (because this is a test) and it only returns one column and one row; select TICKET from lastticket .

 

Do I need to do something special with my stored procedure?

Outcomes