Re: Passing lists to a procedure

From: <paulwragg2323_at_hotmail.com>
Date: 30 Jan 2007 06:53:25 -0800
Message-ID: <1170168804.962629.177640@a75g2000cwd.googlegroups.com>

Thanks Maxim, I will take a look at this as at first glance it is what I need.

Ed - sorry, as you state I did not actually say much about what didn't work. What I meant is that the procedure never actually gets in to the cursor loop - the cursor returns no records. It appears that strTables is not resolved correctly when passing as a list of multiple comma separated table names.

Passing in 'TABLE1, TABLE2' also will not work as these are 2 separate tables, not one table called 'TABLE1, TABLE2' - this is the reason for the number of quotes so that I can pass 'TABLE1', 'TABLE2'.

You have been rather cryptic in your response if I may say so. I believe that I know exactly what my problem is, and how to acheive it. I would be interested in what you are hinting at though because I am now intrigued!!

Thanks,

Paul Received on Tue Jan 30 2007 - 08:53:25 CST