This discussion is archived
0 Replies Latest reply: Nov 18, 2012 8:16 AM by AMSI RSS

insert Procedure command into Target table.Cant Insert Value Prob

AMSI Newbie
Currently Being Moderated
hi,
when i write a Procedure in command=
insert into ETL_FILE(FILE_PROCESSED_COUNT) values
*((select NB_INS from odiwork.SNP_SESS_TASK_LOG where SESS_NO = 493001 AND NB_INS <> 0*
AND scen_task_no = 34 AND NB_RUN = 2 AND NNO = 4))

but when i check it my target table for insertion. there is no record. but this procedure insert one row with values(0).
Wht will b the problem. as i run this query in Sql developer. its working fine. & when i run it in ODI procedure.Its execute successfully. but problem is value

In sql Developer it has given output=10
but in odi when i run procedure it insert =0 values.
as i also check its datatype. its numeric.

Regards,

Edited by: AMSI on Nov 18, 2012 7:59 AM

Edited by: AMSI on Nov 18, 2012 8:15 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points