<div>
To answer the first part: &nbsp;Yes<br />
<br />
declare<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;type arrType is table of varchar2(50);<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myarr arrType;<br />
begin<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myarr := arrType('a','b');<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbms_output.put_line('Firs<wbr />t: ' || myarr(1));<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbms_output.put_line('Seco<wbr />nd: ' || myarr(2));<br />
end;<br />
/<br />
<br />
<br />
I'm not clear what you are asking on the second part.
</div>


To answer the first part:  Yes

declare
      type arrType is table of varchar2(50);
      myarr arrType;
begin
      myarr := arrType('a','b');
      dbms_output.put_line('First: ' || myarr(1));
      dbms_output.put_line('Second: ' || myarr(2));
end;
/


I'm not clear what you are asking on the second part.

<div>
Thank's for your replay, but i need to valorize my array with the field number.<br />
Can i use a syntax like this?<br />
myarr(1) := 'a'<br />
myarr(2) := 'b'
</div>


Thank's for your replay, but i need to valorize my array with the field number.
Can i use a syntax like this?
myarr(1) := 'a'
myarr(2) := 'b'

<div>
<div class="content wysiwyg-content">
Can i declare an array of varchar in a stored procedure or use a structure but calling the structure fields using their position in the structure instead of the name?
</div>
</div>


Can i declare an array of varchar in a stored procedure or use a structure but calling the structure fields using their position in the structure instead of the name?

array in stored procedure

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.