Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> accept prompt and utl_file.put_line
I want to use the utl_file.put_line function in a script(A) to write an accept prompt line in another script(B) in a file. When I run script A, I am asked to provide a value for the prompt. However, I don't want to provide this value until I run script B. I tried two ways to do this:
UTL_FILE.PUT_LINE(myfile,'Accept p_userid prompt '||'''Please enter a userid. If not valid, type NULL: ''');
The previous line didn't work so I tried using a variable with the
value 'Accept' and using this instead:
l_v_accept varchar2(30):= 'Accept';
UTL_FILE.PUT_LINE(myfile,l_v_accept||' p_userid prompt '||'''Please
enter a userid. If not valid, type NULL: ''');
This didn't work either.
Any ideas?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Aug 04 2000 - 00:00:00 CDT
![]() |
![]() |