Procedure Get_RowCount works fine when called independently.
When called from Another procedure it gives the following error.
SQL0206N "C" is not valid in the context where it is used.
SQLSTATE=42703
PROCEDURE Get_RowCount( InSchemaName VARCHAR(30),
InTableName VARCHAR(30),
InWhereClause VARCHAR(1000),
InGroupBy VARCHAR(1000),
OUT RowCount INT)
PROCEDURE LogStart has the following Call
CALL get_RowCount(l_SchemaName, l_TableName ,
l_WhereCLause, l_Group
By , l_RowCount);
Here are the declarations for the variable. used to call the Function.
DECLARE l_SchemaName VARCHAR(30);
DECLARE l_TableName VARCHAR(30);
DECLARE l_WhereClause VARCHAR(1000);
DECLARE l_GroupBy VARCHAR(1000);
DECLARE l_RowCount INTEGER DEFAULT 0;
This gives out the below error
SQL0206N "C" is not valid in the context where it is used.
SQLSTATE=42703
I think the Data Types Match. Whats giving?