Unanswered: Can't prompt for letters, only numbers
I can use PLSQL command Prompt to get user input, but only numbers. If I type in text at the prompt, I get an error. But I need text, and there does not seem to be a way to tell Prompt to accept it. Any ideas?
This is the start of the program:
ACCEPT p_txt VARCHAR2(100) PROMPT 'Please enter the text:';
ACCEPT p_pat VARCHAR2(100) PROMPT 'Please enter the pattern:';