Re: Inputting in a record

On Thu, 06 Apr 2000 10:38:51 +0200, Jonathan Bartolo <jonabart_at_fastnet.net.mt> wrote:

>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;
>
>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'
>
Try dropping the colon. I'm a bit rusty and don't have my references but try price_record.book_price.

However, DBMS_Output won't do what you want. It is intended for debugging and you won't see its output until the procedure completes. Look for another package such as UTL_FILE.

>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 Bartol
Received on Fri Apr 07 2000 - 02:55:01 CEST