INSERT ROWS - DOES NOT WORK [message #21481] |
Wed, 07 August 2002 02:34 |
Cristina Lino
Messages: 1 Registered: August 2002
|
Junior Member |
|
|
Hi there,
I work with Business Objects and right now I'm developping some universes that consists in a set of views of the original Data Warehouse tables.
In order to execute some reports, I tried to insert some rows in one of the tables (in the developping environment). In fact, it worked in the beggining. one of the satements I used was:
INSERT INTO DM_FECHA (ID_FECHA_COMIENZO,ID_MES,ID_ANO,DESC_FECHA)
VALUES (TO_DATE('2002/02/10','YYYY/MM/DD'),2,2,'Diez FEBRERO 2002');
Now, I'm trying to insert more rows in the same table and despite the select * done to the table DM_FECHA,trough Oracle SQL*Plus,showing the new row inserted, the truth is that the same select done trough Business Objects doesn't return the new rowinserted. It means that the table was not updated.
Could you help with this?
|
|
|
|