Newbie to PL/SQL

I am trying to learn how to write a Stored Proc in PL/SQL. I have some experience in SQL, but can't seem to get the syntax right in PL/SQL. Example:

I want to pull records from one table where the id# matches the current id# in the main SQL. I know I could use a join, but it will limit the records from the other tables. I'm also not sure how to call a Stored Proc properly in PL/SQL. Any help would be appreciated.  Thanks.

Bret Received on Mon Oct 14 2002 - 11:15:20 CDT