I am trying to execute a stored procedure through the source query when i am facing this issue.
Database query [EXEC stored_procedure] is empty in JDBC connection:[jdbc:informatica:sqlserver://host:port;DatabaseName=DBName;ApplicationName=AppName,agentid=null;agentGroupId=xxxx;orgId=xxx;]
This issue occurs when i try to validate it.
The SP has a result set from a select statement that i am trying to load into a table, The SP additionally has some temp tables created at run time.
Anybody has any solution to this issue. Thanks.