Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Building a procedure in TOAD

815837Nov 17 2010 — edited Nov 17 2010
I'm converting from SQL Server and am struggling with how to build and test a procedure. In SS I would declare the variables I would use as parameters, assign values and write the code for the query. All this would be done in Enterprise Manager. I need to do something similar in TOAD editor

Declare @ID int
Set @ID = 100
Select * from tablename where IDField = @ID

From this I could then asses the validity of the parameter used by inspecting the results in the grid. Is it possible to do the same in the TOAD editor (I know I can use a literal but I need to test the treatment of the variable).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2010
Added on Nov 17 2010
4 comments
337 views