Oracle DATE problem

HI,

I have problem reading date into an arrau from the database using Pro*C. Here is what I am doing.

char dat[30];

EXEC SQL
  SELECT SYSDATE INTO :dat FROM DUAL;

and I also tried

EXEC SQL
  SELECT TO_CHAR(SYSDATE,'DD/MM/YY HH24:MI:SS') INTO :dat FROM DUAL;

In both the instances it doesn't get anything into the array and the array is empty.

Please let me know by mail or post a reply.

thanks a lot.

Ravi

--
**********************************************************


*   Programmer/Analyst (Oracle DBA)			 *

*   Centre for Technology Innovations in Education	 *

*   University of Missouri - Columbia			 *

*   Columbia MO - 65211					 *

*   Tel # Home - (573)815-9176				 *

*         Off  - (573)882-2162				 *


*   email - kodali_at_coe.missouri.edu			 *


**********************************************************