I have written a procedure, but it is not showing the proper output. As i am a beginner unable to find it out. My desired output is an set of records from a table.
this is my procedure:
Code:
CREATE PROCEDURE FIVESTAR (IN TB_SCHEMA VARCHAR(1024),IN TB_NAME VARCHAR(1024),OUT QUERY1 VARCHAR(1024)) DYNAMIC RESULT SETS 1 LANGUAGE SQL P1: BEGIN -- Declare cursor DECLARE V_DYNAMIC VARCHAR(1024);