Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naveenbmca
Starting Member
1 Post |
 Posted - 2015-01-05 : 23:15:45
|
| Hi All,I am using the Database is Oracle SQL Developer, here the Requirement is like Before insert the values in Database I need to remove the Database table and insert new values. Here i have provided the code below.Please suggest me to resolve this issue. I am new to Reports Builder ,Please assist me Step by Step.Which one is suggested to impliment for this issue.-----------------------------------------------------------------------------DELETE FROM XXMBB_NOSVOS_TMP_VO_NO WHERE EFFECTIVE_DATE BETWEEN '01'|| '-'|| TO_CHAR(to_date(:N_Date,'DD-MM-YY'),'MON-YY')AND to_date(:N_Date,'DD-MM-YY')AND LEDGER_ID = LED and name_rdf='NOSVOS'; COMMIT;DELETE FROM XXMBB_NOSVOS_BAL_TMP_VO_NO WHERE PERIOD_NAME = TO_CHAR(add_months(to_date(:N_Date,'DD-MM-YY'),-1),'MON-YY')and ledger_id = LED and name_rdf='NOSVOS';COMMIT;----------------------------------------------------------------------------------------SRW.DO_SQL('TRUNCATE TABLE XXMBB_NOSVOS_TMP_VO_NO');SRW.DO_SQL('TRUNCATE TABLE XXMBB_NOSVOS_BAL_TMP_VO_NO');When I am Using Delete the following error is came.REP-0069: Internal ErrorREP-57054: In-Process job terminated:Executed successfully but there were some errors when distribute the output.REP-50159: Executed successfully but there were some errors when distribute the output.When I am Using Truncate the following error is came.REP-1425:'afterform':Error Running DO_SQL Package,'Error Parsing the SQL Statement.ORA-01426: numeric overflowPlease suggest me for this issue.ThanksNaveenB.Naveen |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2015-01-06 : 01:46:54
|
| SQLTeam is for SQL Server. Can you post this in www.orafaq.com ?MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
REP-0069 : Internal Error,REP-57054: In process Jo