โ04-13-2023 06:40 PM
Oracle SQL Stored Procedure status is not completing in snaplogic level
while its completed in sql level.
we are passing Date key as a Parameter
โ04-13-2023 06:42 PM
$DATEKEY== 20230301 ITS DYNAMIC.
SQL Statement
select CAST(TO_CHAR(TRUNC(CAST(SYSTIMESTAMP AT TIME ZONE โAsia/Calcuttaโ AS DATE)-20, โmmโ), โYYYYMMDDโ) AS int) as DATEKEY from dual
โ04-13-2023 10:59 PM
Using Oracle Stored Procedure snap, you canโt enter two rows in the โParameter Valuesโ section, and expect it be used as val1 == val2. Pls go thru the snap doc.
If your procedure has two params, then the values given in the settings are supplied as input to those params.
In this case, try using Oracle Execute snap and see if that helps.
โ04-20-2023 11:12 PM
Its Failed only in that condition if row data count exceeds more than 20 lac other its back status as completed.