Hello,
Can anyone help me with option for clearing up the settings and preferences for a stored procedure that is debugged once thru Data Studio. Here is my situation.
1. Created a new native SQL procedure (4 parameters) and deployed and ran couple of debug using routine editor / data project explorer.
2. Dropped the stored procedure and created a new one with same name and additional output parameters (10 parameters) and deployed successfully.
3. When Debug is initiated thru Data Source explorer, Schema > Stored Procedures, it is picking up the old settings (parameter list) and failing
{? = CALL schema.SP_TEST(?,?,?,?)}
NO AUTHORIZED PROCEDURE NAMED schema.SP_TEST HAVING COMPATIBLE ARGUMENTS WAS FOUND. SQLCODE=-440, SQLSTATE=42884, DRIVER=4.13.111
Run of routine failed.
- Roll back completed successfully.
So, my question is how can clear the settings for a stored procedure when it is being dropped or recreated.
Thanks
Topic