Description Ram Venkataswamy 2011-12-05 13:51:42 EST

Build Identifier: M20110909-1335

Data source explorer fails to display MySQL stored procedure 

Reproducible: Always

Steps to Reproduce:
- Create a DB connection to MySQL database (ex: HR schema)

- Open Scrapbook and create a stored procedure

Sample:

CREATE PROCEDURE SP_SELECT_MYSQL
( IN ID VARCHAR(10), OUT IDENTITY VARCHAR(10), OUT PASSWD VARCHAR(10), OUT NAME VARCHAR(10))
BEGIN
  SELECT EMPLOYEE_ID, EMPLOYEE_NAME
  INTO IDENTITY, PASSWD, NAME
  FROM EMPLOYEES
  WHERE EMPLOYEE_ID = ID;
END

- Executing the SQL succeeds

In Data Source explorer, refresh the schema/stored procedure node. The newly created procedure is not displayed.