You can't "send an entire SP". A SP is something stored within the DB (hence the name). You _could_ execute an SQL command containing something like "CREATE PROCEDURE ..." to create a SP on-the-fly, but I think that's not a good solution. If you have several queries you have to execute together, then the SP should be available in the DB, not be created everytime, IMO.
Regards, mav -- Black holes are the places where God divided by 0...