I have a stored procedure to grant a role to a user wherein i pass name,rolename,request no and have a o/p variable to get any success/failure message. i have this working very fine. Now , i plan to create a wrapper around this using vba excel and have a dba input these details and call this SP internally and assign the role. I am facing problems here. I have all the things set, but when i run the SP i get an error :
teradata odbc error : there is a mismatch between number of parameters specified and the number of parameters required.
Could you look into this and help, i am really stuck here and tried as many things as i could, but no luck yet.
I found a solution to this problem. i ran the stored procedure in a bteq and captured the log in a log file from vba. the bteq is run in windows. The o/p success / failure message is displayed and captured in the log after the SP is executed. then in the vba code you can parse the o/p message and find if the SP failed on succeeded. i think it is not possible to get back the message from TD Sp as i initially intened.