Just started to learn oracle database development, the use of navicat premium, but follow learning video tutorials are using SQL, p/l some operations from don't know how, the problem here is to create a simple stored procedure add_dept, according to the tutorial will create good after, the stored procedure need through sql> Execute add_dept to call, but I put it in the storage process behind the create statement is an error, in the query editor is an error, resolution, is can't use it under navicat , so that I insert that is useless, finally want to input data

CodePudding user response:

The stored procedure is required to provide the parameters,

CodePudding user response:

Execute the execution is again a command window,
The call is used in the query window,
The execute immediate within process is the implementation of dynamic SQL