logo
 
 
Product
 
 
 
 
 
documentation/dbg-03-041.php
Previous TopicNext Topic

Running stored procedure

  1. The CALL statement invokes a procedure that was defined previously with CREATE PROCEDURE.

    CALL sp_name([parameter[,...]])

    Select procedure you want and right click on it. Click "Run..." menu item in contex menu.
  2. "Configure parameters" dialog box will apear.
  3. Set parameters and click OK when ready.
  4. To look through results go SQL Results View.
  5. To invoke a function that was defined previously with CREATE FUNCTION.

    SELECT fn_name([parameter[,...]])

    Select function you want and right click on it. Click "Run..." menu item in contex menu.
  6. "Configure parameters" dialog box will apear, as shown in Figure 1.
  7. Set parameters and click OK when ready.
  8. To look through results go SQL Results View.


(c) Copyright Illatis Corporation 2006

Previous TopicNext Topic