SQL Plus setup
I've got something a bit screwy with my SQL Plus setup (at least thats what I think it is) For some reason I cant run scripts using the @ symbol:
SP2-0734: unknown command beginning "crdb_minep..." - rest of line ignored.
Using Oralce 220.127.116.11 - Can anyone suggest anything?
O/S is HP-UX 11.11 - I can still run the get and run commands OK but I've got a big DB creation script that calls lots of other scripts using "@" and I dont want to manually have to get and run loads of different scripts
Its the same for all the 9204 DB's on the server - could it be a UNIX env variable or something? Have compared with a server that is OK and the $PATH, $LIB env variables etc seem to be fine.
Does START work:
From the SQL*Plus manual:
"If the START command is disabled (see "Disabling SQL*Plus, SQL, and PL/SQL Commands" in Appendix E), this will also disable the @ command."
Have you set @ to be the escape char by accident?
What happens if you:
SET ESC OFF
stty erase "^H" kill "^U" intr "^C" eof "^D"
stty hupcl ixon ixoff
set these in your .profile
whats happening is that the @ is being folowed by a carriage return
Thanks for the replies - its seems like daveys solution has worked - thanks again
just to clarify, those are hpux specific things and had me cursing for a long time before finding the answers
I know the feeling! It was driving me round the bend - much appreciated!
Got another nagging problem once I've set these commands. Have set stty erase ^? (instead of ^H for my emulator) and can use backspace in UNIX, but when I login to SQL*Plus and do
SP2-0042: unknown command "sd" - rest of line ignored.
Probably not the best example in the world, but it appears that the screen isnt being updated even though SQL Plus knows that two characters have been deleted. Any ideas?
Click Here to Expand Forum to Full Width