Parameter assignment
From: Jonathan Bartolo <jonabart_at_fastnet.net.mt>
Date: Wed, 05 Apr 2000 12:02:10 +0200
Message-ID: <38EB0F21.B483B113_at_fastnet.net.mt>
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
Date: Wed, 05 Apr 2000 12:02:10 +0200
Message-ID: <38EB0F21.B483B113_at_fastnet.net.mt>
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;
It doesn't work the error is PLS-00049: bad bind variable 'NEW.BOOK.PRICE' Received on Wed Apr 05 2000 - 12:02:10 CEST