Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    secundrabad
    Posts
    1

    Unanswered: stored procedure Problem

    Hi,

    i want to insert one record into master table and mulriple records into detail table with help of stored peocedure by passing values as an arguments . so what data type we have to take . can u explain me with example

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    take the datatypes the table uses

    sp ( par1 table1.col1%TYPE, .... parn table<n>.col<m>%TYPE) ...

Posting Permissions

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