unknown number of bind values

hello plp,
platform:HP-Unix & Oracle

i want to insert into a table values selected from a diferent instance,
stored in an array @tmp.
i want to use something like:
my $query = $dba->prepare('insert into customer values (?,?)')
or die "Couldn't connect to database: " . $dba->errstr;

now my customer table has about 20 fields...
how do i write the prepare statement to accept unknow amount of
bind_values ('?') ??

so i can call it like so:
$query->execute(@tmp);

thanks in advance,
Meni

.

Relevant Pages

  • Re: Table open times and rowsize discontinuity
    ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text - ... For the array fetching, the only parameter I can find in the ADO ... exceeding the SDU and the MTU. ...
    (comp.databases.oracle.misc)
  • Re: Save & Sort
    ... You can copy your array to a scratch ... "Heap" sort. ... Dim lst As Long ... Dim tmp As String ...
    (microsoft.public.excel.programming)
  • Re: Import large CSV file data into Oracle Table
    ... Database: Oracle 10g ... into Oracle Table using a Bulk Insert. ... I would also recommend BufferedStream class to minimize hits to ... ArrayBindSize to the size of the array. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Table open times and rowsize discontinuity
    ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text - ... For the array fetching, the only parameter I can find in the ADO ... exceeding the SDU and the MTU. ...
    (comp.databases.oracle.misc)
  • Re: Table open times and rowsize discontinuity
    ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org-Hidequoted text - ... For the array fetching, the only parameter I can find in the ADO ... Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text - ...
    (comp.databases.oracle.misc)