Store the output of a query which returns multiple rows in a single variable in Oracle
<pre><code>Declare 
v_cardRecord card%ROWTYPE;
v_cardRecords IS TABLE OF card%ROWTYPE;
i BINARY_INTEGER;
Begin
select nt.name, nd.name, ct.name, ps.name, count(c.cardid) BULK COLLECT INTO v_cardRecords
from cardtype ct, card c, node n, nodetype nt, nodedef nd, provisionstatus ps
where ct.name in ('SRA AMP', 'XLA AMP', 'SAM', 'ESAM')
and ct.cardtypeid = c.card2cardtype
and c.card2node = n.nodeid
and n.node2nodetype = nt.nodetypeid
and n.node2nodedef = nd.nodedefid
and c.card2provisionstatus = ps.provisionstatusid
group by nt.name, nd.name, ct.name, ps.name;
</code></pre>

<p>Error"PLS-00103, encountered "IS" when expected one of the following.</p>

<p>2- After that, I want to store the v_cardRecords in another table.</p>

<p>How should I do?</p>