Hello, I've seen the component tOracleSP but my pl/sql block is not stored in the DB, I want to execute it directly. I'm using tOracleRow but it sends me an error and I don't know how solve it.
The PL/SQL block is that:
"begin
for cur in (select owner, constraint_name , table_name
from all_constraints
where owner = 'COMPRAS' and
TABLE_NAME = 'FT_COMPRAS';
execute immediate 'ALTER TABLE '||cur.owner||'.'||cur.table_name||' MODIFY CONSTRAINT '||cur.constraint_name||' ENABLE';
end loop;
end;"
That block works good in SQL Developer or SQL PLUS.
Thanks
PD: ok, already solved, damn pl/sql automatically generated...
