Using database | Generate DDL Script and got the error below. I narrowed it down to Stored Procedures and further narrowed it down to one stored procedure. If I open the stored procedure in the editor, Toad is highlighting "[SCROLL]" - part of the DECLARE CURSOR statement - as a syntax error.
Error produced when generating the DDL for Stored Procedures.
"Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5ParserWrappingException
QP5 parsing error in 'GetSQLObjectNamesPositions'
Stack Trace:
at Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5Parser.GetSQLObjectNamesPositions(QP5ParserDocument qp5ParserDocument, ToadObjectType toadObjectType, Int32 nNamesSetsToSkip)
at Quest.Toad.SqlServer.Common.ScriptUtils.GetScriptObjectOriginal(DBObjectIDStruct dbObjectIDStruct, QP5ParserDocument qp5ParserDocument, StringBuilder sb, ScriptOptions scriptOptions)
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcProperties.GetScript(StoredProcProperties storedProcProperties, StringBuilder sbScript, ScriptOptions scriptOptions)
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcProperties.GetScript(StringBuilder sbScript, ScriptOptions scriptOptions)
at Quest.Toad.SqlServer.Trl.StoredProcs.StoredProcObjectScriptTrl.GetScriptFromDoeObject(ScriptOptions scriptOptions)
at Quest.Toad.SqlServer.Trl.BaseObjectScriptTrl.GetScript(ScriptOptions scriptOptions, Boolean bBackgroundIfCan)
at Quest.Toad.SqlServer.Doe.GenerateDDLScript.DDLScriptProperties.GetScript(SimpleBackgroundTask simpleBackgroundTaskProgress)
at Quest.Toad.SqlServer.Doe.GenerateDDLScript.GenerateDDLScriptForm.GenerateScript()
at Quest.Toad.SqlServer.Doe.GenerateDDLScript.GenerateDDLScriptForm.GetScript()
at Quest.Toad.Doe.BaseDoeForm.UpdateScript()
at Quest.Toad.Doe.BaseDoeForm.selectPageList_SelectedValueChanged(Object sender, EventArgs e)
at DevExpress.XtraEditors.BaseListBoxControl.Rai
WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for SQL Server
