Big number host variables in pro*C ??

Hi,

I have a table with a key value defined as NUMBER(13)

I want to use a simple select query in pro*c - something like :-

EXEC SQL SELECT BLAH

	 INTO :blah
	 FROM BLAH_TABLE
	 WHERE KEY = :key_value;

The question is "how do I define the host variable `key_value' ?". The type 'long int' does not enough precision for 13 digits and 'float' or 'double' cause a segv error.

I know I can get around this using dynamic SQL but I'd rather not.

Thanks for any help,
John Received on Tue Oct 25 1994 - 15:49:27 CET