| Reports based on Object Types [message #89698] |
Mon, 28 June 2004 20:12 |
Inderjeet Singh
Messages: 13
Registered: April 2004
|
Junior Member |
|
|
Hi All,
I am using Oracle 9i & Developer 6i on Windows platform in client/server environment. I created a report based on an Object Type defined in the Database. I am facing two problems in that:
1. Its not picking up Date columns properly. When I run the report, I receive error: "REP-0612: Invalid Date Mask.
ORA-01801: date format is too long for internal buffer.".
When I checked, I noticed that all the date columns in my Data Model, which are coming from Object Type are of Width 9 only. I want to ask how is it so, & how can I sort it out. I have not specified any format model for dates neither in Object Type nor in Report anywhere.
2. Another thing is, after reopening the report, in the report builder, i mean closing & then opening the .rdf file, when I try to run the report, I receive following error: "REP-0499: Column 'Column_Name' selected by the query is incompatible with report defination". This column is one of the columns/attributes of the object type on which my report is based. Though, nothing has been changed in the object type or any other database object, it gives this error, everytime, I try to run the report, after closing it(after proper saving) & opening it again. Can anyone help me by telling, why is it happening like this.
Thanks in Advance,
Inderjeet Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
