Re: Oracle DATE problem

In article <4j5e8b$16re_at_news.missouri.edu>, Ravi Kodali (kodali_at_new.missouri.edu) says...
!>
!>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
!>

Some time ago I posted a suggestion for april fool's day : add a second row to the dual table.

It's hard to imagine, but would you have a dual table without any rows?

That is, in sqlplus, what does 'select sysdate from dual' yield?

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard