| |

VerySource

 Forgot password?
 Register
Search
Author: wang7498

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

[Copy link]

2

Threads

19

Posts

16

Credits

Newbie

Rank: 1

Credits
16

 China

 Author| Post time: 2020-5-20 15:45:01
| Show all posts
No. Still the same error.
I really doubt there is a problem with my ORACLE.
Reply

Use magic Report

2

Threads

19

Posts

16

Credits

Newbie

Rank: 1

Credits
16

 China

 Author| Post time: 2020-5-20 19:45:01
| Show all posts
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 ...
Reply

Use magic Report

0

Threads

37

Posts

22

Credits

Newbie

Rank: 1

Credits
22

 China

Post time: 2020-5-21 23:15:01
| Show all posts
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
Reply

Use magic Report

2

Threads

19

Posts

16

Credits

Newbie

Rank: 1

Credits
16

 China

 Author| Post time: 2020-5-27 17:00:02
| Show all posts
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.
Reply

Use magic Report

2

Threads

19

Posts

16

Credits

Newbie

Rank: 1

Credits
16

 China

 Author| Post time: 2020-5-27 19:15:01
| Show all posts
Tried it again. Can COMMIT
But BEGIN ..END must be. Ha ha. This is the problem.
Reply

Use magic Report

0

Threads

37

Posts

22

Credits

Newbie

Rank: 1

Credits
22

 China

Post time: 2020-5-28 01:45:01
| Show all posts
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
Reply

Use magic Report

0

Threads

37

Posts

22

Credits

Newbie

Rank: 1

Credits
22

 China

Post time: 2020-5-28 07:00:01
| Show all posts
sqlserver is automatically submitted
This gap is still very big
Reply

Use magic Report

2

Threads

19

Posts

16

Credits

Newbie

Rank: 1

Credits
16

 China

 Author| Post time: 2020-5-31 14:30:01
| Show all posts
Oh basically understand. Thank you very much.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list