This content has been marked as final. Show 2 replies
in PL/SQL scripts you just omit the "execute". and for the SQL you need to put an execute before it.
so your script would be:
apart from that, you should be modifying MyTable_LTS in your DDL session.
begin dbms_wm.beginddl('MyTable'); execute immediate 'ALTER TABLE MyTable ADD NewColumn1 VARCHAR2(200)'; dbms_wm.commitddl('MyTable'); end;
Great thanks, aschilling. That solves my problem.
Something off-topic but interesting is: i've got a work fellow and today i asked him this question too. He then searched for a min and gave me a link that he thought answers my question. And that's this URL!!! LOL. What a small world! I hadn't changed my Handle so he didn't recognize this is my post.
This might be an indicator that there're really many ppl using WM.