When I am trying to call a stored procedure in SQL Anywhere 16 via dbisql with the following command:
When I am connecting to the database with the same connection string:
I can find the stored procedure in sysobject table: (SAAP)> select * from sysobjects where type = 'P' and name like 'sp_sync_reset%';
name id uid type userstat sysstat indexdel schemacnt sysstat2 crdate expdate deltrig instrig updtrig seltrig ckfirst cache audflags objspare
sp_sync_reset_template 13061 1 P 0 0 0 0 0 (NULL) (NULL) 0 0 0 0 0 0 0 0
Why is dbisql showing procedure not found when the procedure is present in the database?
Note: this is the body of the procedure
One possibility is that the procedure is not visible because it is owned by a different user id (e.g., DBA) so the CALL should be qualified: CALL DBA.sp_sync_reset_template()
You might also need a GRANT EXECUTE on DBA.sp_sync_reset_template TO saap.
answered 09 Feb, 07:02