> iErr = sqlexec(iConn,'execute test.sp_test_call;')
In your call to the SP, are you using correct naming convenbtions? By that I mean tblowner.package.function(arglist), or within Oracle, have you declared the package (SP) with a PUBLIC synonym, and given PUBLIC rights to execute? If you login to sql+ as the owner, it will naturaly work for you, so log in as a regular user and rty it to ensure correct rights are granted.