Re: Parameter assignment

Jonathan Bartolo wrote:

Hi
I have a procedure which has a parameter. How can i assign that parameter to a field in a table.
Eg. I have a table - book and this table has price as one of its fields

Create or replace procedure tran2(Book_price book.price%type) is ....
:new.book.price:=book_price;
 

Update mytable
     set  mytable.price = book_price
  where (conditions) Received on Wed Apr 05 2000 - 12:21:32 CEST