So when you see the promptmany macro function in Cognos, one gets all excited with the prospect of an application allowing you to use an array. ![]() ![]() Of course programmers would rather bite off their arm than willingly write a cursor if there is another viable alternative. Traditionally, Sql programmers use cursors to handle passing individual values one at a time to a procedure. This is a problem if you want and need to pass multiple values to a stored procedure. By nature if a stored procedure has parameters, you can only set the parameter equal to a single. Error QE-DEF-0406 is normally generated when you try to use the function to pass multiple values to a Sql stored procedure. ![]() The promptmany macro function error message is such a letdown. Cognos BI Promptmany Macro Function Error
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |