Xref: alice comp.databases.oracle.tools:42176 Message-ID: <38E8C894.28D5EC45@fastnet.net.mt> Date: Mon, 03 Apr 2000 18:36:37 +0200 From: Jonathan Bartolo X-Mailer: Mozilla 4.7 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.tools Subject: Update transaction Content-Type: multipart/alternative; boundary="------------77219477F58D9E4AC692B294" X-Trace: 3 Apr 2000 18:28:56 +0200, d1m04.fastnet.net.mt Lines: 77 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed00.sul.t-online.de!t-online.de!bignews.mediaways.net!newsfeed.nettuno.it!server-b.cs.interbusiness.it!news.waldonet.ent.mt!d1m04.fastnet.net.mt --------------77219477F58D9E4AC692B294 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Can I update a field of a table from a procedure. I have this procedure
create Procedure Tran2 (publish IN book.publisher%type) is
Type price_data_record is record
(ISBN_NO book.ISBN%TYPE,
   book_name book.name%TYPE,
   author_name book.author%TYPE,
   book_price book.price%type,
   new_book_price book.price%type);
   price_record price_data_record;
CURSOR c2 is
Select ISBN, name, author, price
from book
where book.publisher = publish;
Begin
Open c2;
LOOP
Fetch c2 into price_record;
exit when C2%NOTFOUND;
DBMS_output.Put_line('ISBN No '|| price_record.ISBN_NO);
DBMS_output.Put_line('Name of Book '|| price_record.book_name);
DBMS_output.Put_line('Author '|| price_record.author_name);
DBMS_output.Put_line('Price Lm'|| price_record.book_price);
DBMS_Output.Put_line('New Price'||:new_book_price);

This line is the problem ... I need to update this record with a new price. But the user has to input the new price.
When I try to compile this procedure it telling me that i have a bad Variable bind
Can you help me please

Regards
Jonathan --------------77219477F58D9E4AC692B294--