Stored Procedure with Substitution Type Variables? 1

[Robertio]

I'm sure there must be a simple way of doing this, but can't find it, so...

I have a stored procedure which I want to pass in a table name to, then run the query on this table.

ie:
insert into ivTable (select * from ivSource where ...)

Where ivTable and ivSource are both passed in.

Any ideas?

Thanks Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk

 

[lewisp]

EXECUTE IMMEDIATE 'insert into ' || ivTable || ' (select * from ' || ivSource || ' where ...) ';

 

[Robertio]

Thanks Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk