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.