OraFAQ Forum: Data Integration » can't delete data from extracts table (mapping)

Home » Developer & Programmer » Data Integration » can't delete data from extracts table (mapping) (10gr2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can't delete data from extracts table (mapping) [message #319382]

Sat, 10 May 2008 05:59

domisj
Messages: 4
Registered: May 2008
Location: Vilnius

Junior Member

hello,
i can't delete data from extracts table in mapping there is condition (i need to delete if it's the same batch_no in table and parameter): where gl_batch_no in (0,i_batch_no); (i_batch_no - is parameter)

table load type: delete/insert
conditional loading->target filter for delete: gl_batch_no in (0,gl_batch_no_1);

any suggestions?

Report message to a moderator

Re: can't delete data from extracts table (mapping) [message #319586 is a reply to message #319382]

Mon, 12 May 2008 05:35

domisj
Messages: 4
Registered: May 2008
Location: Vilnius

Junior Member

Solved!

Report message to a moderator

Re: can't delete data from extracts table (mapping) [message #319718 is a reply to message #319586]

Mon, 12 May 2008 15:19

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's really nice, but noone (but you) knows what you did in order to solve the problem. The next user who gets into the same trouble won't be able to learn anything from your case.

So, would you mind to post the solution, please?

Report message to a moderator

Re: can't delete data from extracts table (mapping) [message #319806 is a reply to message #319382]

Tue, 13 May 2008 01:51

indxe
Messages: 4
Registered: May 2008
Location: Jordan

Junior Member

Thats great ..... can you post the solution, just not to face the same problem in the future ...
thank you Smile

Report message to a moderator

Previous Topic:	Why we need Enqueue_Resources as 3000 to install OWB 10.2 Repository Server
Next Topic:	Categorising information,

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:11:17 CST 2024