DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    how to use reserved words???

    Hi all

    I have a procedure and it has the following statement in it

    p_statement_header := 'EMP ACCOUNT - TAX INVOICE & ADVICE OF PAY';

    So when I try to create the procedure it asks me to input the value for advice.
    Enter value for advice:

    and I just press enter and everything goes fine. But I dont want it to ask me for the value and I use the following to get rid of it:

    p_statement_header := 'EMP ACCOUNT - TAX INVOICE'||' & '|| 'ADVICE OF PAY';

    Is there any other way other than this???????

    Please let me know.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    in sql*plus "set define off"
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.