How to use embedded sql to define an array

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.


Thanks,
Jeff



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();       }