-
When I tried to create a procedure, I got warning message that 'Procedure created with parsing errors'. So how should I debug my code? Any tools available?
Thanks!
-
Could you post the procedure and your database version?
Since this would be better answered in the development forum, I'm moving it to the development forum from the administration forum...
Sam
Thanx
Sam
Life is a journey, not a destination!
-
My database version is Oracle 8.1.7 under Win2K.
The procedure I was trying to create should be able to change the tablespace for all indexes that an user has.
CREATE or REPLACE procedure chg_ind_tbs as
cursor c1 is select index_name from user_indexes;
BEGIN
FOR result IN C1 LOOP
ALTER INDEX result rebuild tablespace tbs_name;
END LOOP;
END;
-
Hi,
Replace string
ALTER INDEX result rebuild tablespace tbs_name;
in your code with
execute immediate 'ALTER INDEX '||result.index_name||' rebuild tablespace tbs_name';
(If "tbs_name" in your code is a tablesapace name, not a parameter.)
Hope this helps,
-
Thanks Dmitriy! It's now working...
-
Shall I execute this procedure using
execute chg_ind_tbs ?
I tried to do that, but it seems that it was not working -- hanging there w/o doing anything.
Any idea?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|