I as you can see from the procedure code.... I printed the values and the output is like
912751 wrote:I am trying to get you to think for yourself: you won't get very far if people just spoon-feed you.
I have tried so many things... but I am not able to get the required format. Each time its comes like 10-AUG-12
If I am using it as timestamp then its giving ORA-14020
Could you please help me?
bcm@bcm-laptop:~$ oerr ora 14020 14020, 00000, "this physical attribute may not be specified for a table partition" // *Cause: unexpected option was encountered while parsing physical // attributes of a table partition; valid options for Range or // Composite Range partitions are INITRANS, MAXTRANS, TABLESPACE, // STORAGE, PCTFREE, and PCTUSED; only TABLESPACE may be specified // for Hash partitions // *Action: remove invalid option(s) from the list of physical attributes // of a table partition // *Comment: this error could have resulted from omission of a // terminating (right) parenthesis following the list of // partition descriptions