What is correct Pro*C syntax for selecting max?

I'm writing a Pro*C program that needs to select a maximum on a column.

If I write the Pro*C as

     EXEC SQL SELECT max(seq_number)
     INTO :max_seq
     FROM protein_sequence

It hangs up. Removing the max fixes things, but that isn't the result I want.

Sqlplus is perfectly happy with the analogous statement:

   SELECT mac(seq_number)
   FROM protein_sequence;

IS it possible to do this in Pro*C? Received on Thu Dec 17 1992 - 13:01:12 CET