Procedure:

PROCEDURE "test" (IN "w" VARCHAR(512) COLLATE ANSI, OUT "ou" VARCHAR(512) COLLATE ANSI)

BEGIN 

  -- in w is here a dummy

  DECLARE v varchar DEFAULT '';   

  DECLARE stdCursor CURSOR FOR Stmt;

 

  PREPARE Stmt FROM 'SELECT * FROM KA_HASTD';

  OPEN stdCursor;

 

  FETCH FIRST FROM stdCursor (AbObjektbezeichnung) INTO v;

  Close stdCursor;

 

  set ou = v;

END

Script:

SCRIPT

BEGIN  

  DECLARE ou varchar(512);

  DECLARE t4 varchar DEFAULT ''; 

  DECLARE stmt STATEMENT;

 

  call test('', ou);

  set t4 = ou;

  SET log MESSAGE TO t4;

END