'PowerShell Array dimensions exceeded supported range

i'm trying to get data for bulk copy from oracle. I use powershell for this. I ran into such a problem that if I take a longer period, I get an error Exception calling "Fill" with "1" argument(s): "Array dimensions exceeded supported range." As a result, not all data is received.

I load $dtbl by reading data from the request: After I do fill:

$adapter = new-object Oracle.ManagedDataAccess.Client.OracleDataAdapter($q, $connstr);
$dtbl = new-object System.Data.DataTable;
$adapter.Fill($dtbl);

Have an idea how to solve the error?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source