Originally posted by Vicky Mohan:
Thanks.
But it was working in one environment and not working in another environment.
so, i was wondering if this has got to do with different version of oracle.
I don't have an answer except that is quite possibly an issue with using an old Oracle release (8 is no longer supported)... It isn't really anything I think is going to be terribly worthwhile in getting a definitive answer for what is probably an 8x issue. I would just go with the code that worked in both environments.
here is the link to the command reference for sqlplus.
http://download.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1011097 [ October 07, 2008: Message edited by: Paul Campbell ]