|
|
|
|
|
When you display a Stored Procedure in AQT, you can see:
There is one little trap with these - the system table that holds the procedure parameters is only populated when the procedure compiles successfully. So, if your procedure has not yet compiled OK, you can see the text for it in the Database Explorer, however the parameter-list will be empty.
When you create a new Stored Procedure, you enter the parameters on a separate tab in the window. However when you display or modify the procedure, you will not be shown this tab. This is because, if your SP has not compiled successfully, the parameters can not be shown. Instead you are shown the full procedure text.
When you create or alter a View, Stored Procedure, Function or Trigger through AQT, a lot of the formatting is lost. This problem happens because the Oracle ODBC Driver removes duplicate spaces from your SQL.
The solution is to use the Microsoft ODBC for Oracle ODBC Driver.