Procedure compilation errors

[Sambo8]

Hi there,

I'm having a problem with my procedure I want to execute an alter trigger for every tablename in the audittables table concatanate the AUA to the tablename.

Here's my code:

Create or Replace procedure samtest.disable_trigs

IS

tabname IN varchar2(30)

Begin

select 'AUA'||tablename
into tabname
from samtest.auditing
where tablename <> 'auditing';


EXECUTE IMMEDIATE 'ALTER TRIGGER tabname DISABLE';

END;

/

Please can you tell me where I'm going wrong?

Many thanks,
Sam

 

[Thargy]

The execute immediate statement is invalid. Try using

EXECUTE IMMEDIATE 'ALTER TRIGGER '||tabname||' DISABLE';

Also you need to set up a 'cursor for loop' to do each one in turn.

Regards

T