I was in contact with ORCALE for the first time today.

wang7498

No. Still the same error.
I really doubt there is a problem with my ORACLE.

wang7498

OWNER of MYTEST is SYS.
1.
 EXECUTE SYS.MYTEST ('AA')
Same error.

2.

set serveroutput on
EXECUTE SYS.MYTEST ('AA');
Prompt error. Said missing expression ... serveroutput is invalid ...

idpublic

sqlplus test

set serveroutput on;
begin
user.test_ll_01 ('aa'); --user is replaced with your own user
end;


lz you see clearly, there is a semicolon, there is begin end

wang7498

Succeeded ...
Thank you !!!!!! ^ _ ^
But there are a few doubts.


I wrote it this way.
BEGIN
SYS.TEST ('AAA');
COMMIT;
END;

Basically the same as yours. Why COMMIT? Can't COMMIT automatically?
Why do you have to BEGIN ... END?
SYS.TEST ('AAA');
COMMIT;
This is considered to be 2 processes.

wang7498

Tried it again. Can COMMIT
But BEGIN ..END must be. Ha ha. This is the problem.

idpublic

COMMIT;
The oracle is required to submit, DDl statement is automatically submitted
The dml statement is about to commit yourself

--------
Use begin end when executing anonymous fast in Oracle
This is a grammatical rule

idpublic

sqlserver is automatically submitted
This gap is still very big

wang7498

Oh basically understand. Thank you very much.