Search results for query: *

Unfortunately, in this case there are no triggers. Looks like it's time for an SR. Thanks to you and everyone for taking time to look into this for me. At least you validated that I wasn't going crazy.

Correct. The statement you posted will throw an error. It will also throw an error if you decide to leave the sysdate out alltogether, and ignore the input to the ROW_ADD_TMS.

There are no other columns with a DATE datatype. I remove the ROW_ADD_TMS column and the insert works. Weird, huh?

Column Name: ROW_ADD_TMS ID: 12 Pk: Null?: Y Data Type: DATE Default: sysdate Histogram: No

insert into PROD.TBL_PROD_ME (MNTH,HOURS_NOHOURS,NAME,TOTAL_STFD_TIME,COLLECTOR,COMMENT_ADDED_ID,CALLS,CONTACTS,PROM_TO_PAY,KEPT,SUPERVISOR) SELECT MNTH, HOURS_NOHOURS, NAME, sum(case when TOTAL_STFD_TIME is null then 0 else to_number(TOTAL_STFD_TIME) end)...

Hello I am inserting data into a table and have a ROW_ADD_TMS column that is set in the table to default at the sysdate. When I attempt to insert data, this field throws the following error: ORA-01840: input value not long enough for date format When I try take the default value off of the...

Thanks for the idea. However, when I do that, it gives errors after each back slash saying something to the effect that an 'escape' had been found coded multiple times.

Hello I'm trying to use VB.NET to save an open spreadsheet to a network drive and am receiving errors when run the code. Here's the line where the problem exists. excelWorkbook.SaveCopyAs("//wsent01ts/callgrp/reports/Accts 120 ME.xls"); I can save it manually to this path...

Hello We have a development and production regions for our oracle environment that support reporting in Excel pivot tables. How do we point our pivot tables in the development schema to the production schema without having to rebuild them from scratch? Thanks!

Hello We have an app that opens, refreshes and publishes a ton of Excel spreadsheets with pivot tables to a web folder. Most of the spreadsheets update fine. However, one just keeps being published with the data from the exact same date everyday. Below is the code. Section 1 is an example of...