Hi, As the subject stated, How can i call a stored proc in the CommandText in a config file? I have been searching for it, but i'm unable to find a concrete example on it. The docs simply said we can write insert statements, or stored proc there. But i failed to execute my stored proc. (which works fine if i use insert statement, and the stored proc works fine in sql analyser) i tried <commandText value="exec testLogging @message"/> and <commandText value="testLogging @message"/> and they didn't work. certainly the stored proc name is testLogging and it takes a varchar as parameter.
What am i doing wrong? The simple stored proc contains only an insert statement.. it works fine when i substitute <commandText value="insert into sys_trans_log_header_history (dealid,groupid,lstUpdDate) values (@message,999, getDate())"/> Thanks. Pat PS: i would like to thank Kiran Raja and Mike Collier for their help in the thread "Question on Logging customized information"
