I am trying to create a stored procedure and I need to learn if it can be done via SQL assistant. Its a simple procedure takes in 2 values compares them sends out result of the greater number. The challenge I am facing is that the create statement gets completed when I use F9 . However neither does the Tool Show me it's definition nor I am able to call it says procedure does not exist. How can it say procedure created and still its not found ... Pls help . Thx in advance!!
It can be done using SQLA.
Are you qualifying your create procedure statement as well as your show procecdure statement with the database name ?
Possibly a default database issue.