Re: Oracle DATE problem

kodali_at_new.missouri.edu (Ravi Kodali) wrote:
>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 *
>**********************************************************
I think Pro*C 2.0 is different but in 1.6 you must code the following:

char dat[30];
EXEC SQL VAR dat is string(30);

Ken Denny
Insight Industries, Inc.
RTP, NC
All opinions, etc (you know the bit). Received on Tue Mar 26 1996 - 00:00:00 CET