I'm writing a procedure to rebuild indexes from one tablespace to another. The procedure compiles fine but when I run it I get the following error:
HDEV8> exec rebuild_indexes('PSINDEX','PSINDEX1','N','N');
BEGIN rebuild_indexes('PSINDEX','PSINDEX1','N','N'); END;
*
ERROR at line 1...