I have issue with the following code

after migrating it from oracle this is how it got compiled but it does not enter into Dbms_Sql.Parse ,Dbms_Sql.Variable_Value_VARCHAR and Dbms_Sql.Bind_Variable_VARCHAR.

DECLARE
lv_ret VARCHAR2(2000);
cur PLS_INTEGER; --:= Dbms_Sql.Open_Cursor;
fdbk PLS_INTEGER;
lv_stack INTEGER;
BEGIN
lv_stack :=(1729.78*1)*1;
Dbms_Sql.Parse(cur,'BEGIN :val := ' || lv_stack || '; ND;',Dbms_sql.Native);
Dbms_Sql.Bind_Variable_VARCHAR(cur, 'val', 'a', 2000); -- Dbms_Sql.Bind_Variable (cur, 'val', 'a', 2000);
fdbk := Dbms_Sql.EXECUTE (cur);
Dbms_Sql.Variable_Value_VARCHAR (cur, 'val', lv_ret);
Dbms_Sql.Close_cursor(cur);
lv_stack := lv_ret;
EXCEPTION WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20020,SQLERRM);
END;

so what is the problem : is this code for db2 as this has been submitted in the db2 forum..

yes it is in db2....it gets compiled in DB2 but dsnt give out any output neither it raises any exception...!!


it just gives an empty output...