Create Array in a stored procedure

1

I am migrating a stored procedure from Oracle to Sql server and I have this problem.

It turns out that they occupy a varray within the code. I do not know how to do it in SQL. Searching for different pages, some recommend that a table be made and a SELECT done, the problem is that they ask me not to change the structure of the SP and to be as similar as possible.

 Type oCampos Is Table of Varchar(40);

 vDatoPoliza oDatoPoliza;
 vDato       oDato;
 vCampo      SET @oCampos = oCampos();

 vHeader     SET @oCampos = oCampos();
 vMonCpo     SET @oCampos = oCampos();

I appreciate your comments and suggestions. Greetings.

    
asked by AldoPilgrim 12.02.2018 в 23:43
source

0 answers