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>
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