Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    6

    Unanswered: Calling Stored Procedure Dinamically

    How can I call a SQL Stored Procedure dinamically?
    I try this code but don't work...

    create procedure sp_dinamicproc
    ()
    language sql
    begin
    declare SSQL varchar (1000);

    SET SSQL = 'CALL sp_test()';

    prepare stmt from SSQL;
    execute stmt;
    end

    thanks!

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    Just create a while loop with counter set to 1000 and call the procedure in the loop by decrementing it by 1 till it gets to 0...

    cheers,
    Prashant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •