howto declare variable sized array w esql

Hello everyone,

Can someone please tell me how to declare an array of double (float8) 
using esql  when you
don't know how long the array is until runtime?

I have the code work for a fixed length of 10, but at run-time I might only
put 2 values or there could just as easily be 100 or 200 or 5000!

I tried several variations declaring my array as a pointer, but ecpg did 
not like
any of my attempts.

If I must and it someone can confirm, I guess I could declare the array 
as some fixed
max size and then save just the slice? How to do that?



Thanks,
Jeff


Here is some code I am trying:

void    myinsert(const std::vector<double>& myVector)          {          EXEC SQL BEGIN DECLARE SECTION;
           /* this would be ideal but ecpg does not like it */           /* double          m_data[myVector.length()];
*/
          /* This works but length might actually be 1 or 200! */          double          m_data[10];
          EXEC SQL END   DECLARE SECTION;
      /* stuff the sql array with data from my stl vector */      for ( unsigned int i=0; i < myVector.length(); i++ )
           m_data[i] = myVector[i];
 
      EXEC SQL              insert into eraDATA                    ( data )              VALUES(  :m_data );
returnsqlOK();      }