I'm having difficulty with this script. Just want to create a user on the fly. Will install a cursor later so I can spin thru our employees and add a new user for each one.
I'm getting the error:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:
( begin case declare exit for goto if loop mod null pragma ...
ORA-06512: at line 15 (The execute immediate is on line 15)
This is the output to the put_line, which is what I want:
Create User O$PI\BILL Identified externally ;
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.