Re: Array Fetch - Array Insert

Hi,

With embedded SQL, to array fetch a statement like: select sal, ename
into :sal, :ename
from emp

you just declare your variables as arrays of a fixed length (say 100). Oracle will populate all 100 fields. The last fetch you have to find out yourself how many items were fetched. You can use the SQLCA to do this.

Gerrit-Jan Linker
http://members.aol.com/gjlinker Received on Sat Apr 10 1999 - 12:30:59 CDT