Need help in finding (Oracle dynamic Sql with using class) equivalent to Teradata
Is there any way to use bind variables in Teradata stored Procedure with dynamic Sql,
Actually my requiremet is like this,i Have an Oracle procedure which contains an update stmt with Dynamic sql and using clause,can anyone please give me some information regarding this..it is an urgent reuirement,need ur valueable inputs for to find a way to this..
begin execute immediate 'insert into dept values (:1, :2, :3)' using 50, l_depnam, l_loc; commit; end;
Note: In my case the using clause variables are not declared in the declaration part,they were used as bind variables..the same how we can implement in Teradata...