With v8.5 and ODBC and Stored Procedures, you are going to be limited to the Start Transaction and Commit statements (
http://www.pervasive.com/library/doc...ref-4-13.html).
Why do you want to lock the whole table? What does your Stored Procedure do?