Re: define table name as parameter in spl

From: Andrea Verni <andrea.verni@telital.com> > >I need to create a general stored procedure to modify always the the >same column name but in different tables. > >Can I pass the table name to a procedure from a trigger and then, how >can I use it in the procedure ? > >I tried to execute something like: "select * from $table_name" but it >doesn't works.... You can't do dynamic SPL. However, if you're using 9.x, you can compile in Lord Paul Brown's Dynamic SPL DataBlade, which will allow dynamic SPL. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com