Results 1 to 2 of 2

Thread: stored procedure

  1. 07-15-2004, 03:53 PM #1
    GarryD
    GarryD is offline Registered User
    Join Date
    Jul 2004
    Location
    DC
    Posts
    8

    Unhappy stored procedure

    I have a table with a
    ID
    Item
    Item_type
    I need a sp that returns all field, insert into the table and update based on ID. Any Ideas
    Reply With Quote Reply With Quote
  2. 07-16-2004, 08:54 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can create one procedure for each type of activity or create one that accepts parameter to distinguish different activities.

    Only way to return a result set is to use REFCURSOR, if you are only returning one row then you can use OUTPUT variables for that.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules