Inputting in a record

From: Jonathan Bartolo <jonabart_at_fastnet.net.mt>
Date: Thu, 06 Apr 2000 10:38:51 +0200
Message-ID: <38EC4D19.F72578B_at_fastnet.net.mt>



Hi

I created this record

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; [Quoted]

This record is stored on a procedure called X

I wish that when the user when he executes procedure X is prompted to
inputs a new_book_price. So I did the following code

DBMS_Output.Put_line('New Price Lm'|| :new_book_price);

But the an error occured  PLS-00049: bad bind variable 'NEW_BOOK_PRICE'

I tried other words like :new.new_book_price or :new.price_recrd.new_book_price
but the outcome was the same as before.

Can anyone please help me

Thanks
Jonathan Bartolo Received on Thu Apr 06 2000 - 10:38:51 CEST

Original text of this message