DSXchange

Ok i see, but is my syntax correct?

PROCEDURE myproc(ANO OUT OAD_F_SUIVI_ANOMALIE.ANO_IN_ID_ANO%TYPE)
AS BEGIN
SELECT ANO_IN_ID_ANO INTO ANO FROM OAD_F_SUIVI_ANOMALIE WHERE ANO_IN_ID_ANO=34;
END;

Thx,

I have this in my log : Untitled1..Stored_Procedure_6: OCIAttrGet - Must be an anonymous pl/sql block being prepared. Untitled1..Stored_Procedure_6: PROCEDURE myproc(ANO OUT INT) AS BEGIN SELECT ANO_IN_ID_ANO INTO ANO FROM OAD_F_SUIVI_ANOMALIE WHERE ANO_IN_ID_ANO=34; END; Attempting to Cleanup after...

Can anyone help me My job design is like that : SFile --> STP (Stored Procedure Stage) --> SFile In STP Stage, I clear "Generate procedure call" and I edit this syntax : PROCEDURE myproc(ANO OUT INT) AS BEGIN SELECT ANO_IN_ID_ANO INTO ANO FROM OAD_F_SUIVI_ANOMALIE WHERE ANO_IN_ID_ANO=34; E...

Thank you Roy your solution, i succeeded to create a sequential flat like that : <LINE> 1 US FR IT GR 2 GR BG but i didn't find how i can store my number in a stage variable for having in output : <ID_COUNTRY>,<LANGUAGE> 1,US 1,FR 1,IT 1,GR 2,GR 2,BG Thanks in advance,

Hello, I was wondering if anyone know or perhaps provide some solution to the following? I need normalize each row on a field. I know we can do it with hashed file bu i'm developping on parallel job. source : TABLE1 (ID_COUNTRY, LANGUAGE) --> the column LANGUAGE is very variable from NULL to 400 sit...