Stored Procedure OUT parameters are not added to editor windows when editing proc scripts

[DM1145]

When OUT parameters exist in redshift stored procedures and the stored proc is loaded into a SQL script window for editing, the application drops OUT parameters (those that return values from procedures) from the script. Should the script in the window be executed to update the proc, the parameters are dropped from the proc unless they are manually added back.

Found in SQLPro Studio Version 2023.35 (Build 111030)

[hankinsoft]

I haven't been able to reproduce this. Could you please provide the following details:

Environment details (please complete the following information):

• Device: [e.g. iPhone6, MacBook]
• OS: [e.g. iOS8.1, macOS 11]
• SQLPro app Version [e.g. SQLPro Studio 2022.x] Please ensure you specify the full app name. (ex: SQLPro Studio, SQLPro for MySQL, etc).
  • Installation source: [App Store, Website download, Setapp].
  • Target database server [e.g. MySQL, PostgreSQL, Microsoft SQL Server, etc]

    ---

Along with the database server version? Ideally a sample create script which you can use to reproduce would be great as well, as I'm not sure how/why I'm not seeing this.

[hankinsoft]

And to confirm, are you talking about stored procedures or functions? (And if possible a sample script which can be used to reproduce would be great).

[hankinsoft]

Closing as I have been unable to reproduce.