Re: SQL*Plus not parsing "create trigger" and "create type" commands
Date: Fri, 31 Mar 2000 16:04:26 GMT
Message-ID: <8c2ia2$u18$1_at_nnrp1.deja.com>
Sean,
You are in the "editor" portion of sql/plus. The same thing happens when you type DECLARE...etc.etc. The period is the proper command to exit the editor back to the command level. You must enter a slash (/) to cause execution to happen.
Suppose you wanted to use the local editor.
You would type ED and probably NOTEPAD would
appear with your trigger text. When you close
the editor, the text would be "re-entered"
into sql/plus, and then it would sit there,
at the command prompt just waiting...
Once again, you would have to type slash (/)
to cause execution.. (or in your case, compilation
and storing...)
Robert Proffitt
Beckman Coulter
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Mar 31 2000 - 18:04:26 CEST