Is there a way to alter an already compiled stored procedure in sybase? The only way to do it seems to drop the SP and create it again. I am looking for an equivalent of REPLACE(in Oracle) or ALTER(in SQL Server) in sybase.
you can recompile a stored proc. in sybase(for that stored proc. only) by using
exec <sored_proc_name> with recompile
however this will create an additional query plan(potentially different) for the stored proc in the procedure cache.
I am not aware what replace or text does but if you want to change stored proc. text in sybase you will have to drop and recreate the stored proc.
sp_recompile/with recompile options are used for generating a new query plan in sybase.