OraFAQ Forum: Client Tools » Is there a difference between procedure successfully completed and anonymous block competed? (merged 3)

Home » SQL & PL/SQL » Client Tools » Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) (sql)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646508]

Sun, 03 January 2016 07:38

cleverwat
Messages: 6
Registered: January 2016

Junior Member

If yes how can I change it when running the script?

[Updated on: Sun, 03 January 2016 07:49]

Report message to a moderator

Is there a difference between procedure successfully completed and anonymous block competed? [message #646509 is a reply to message #646508]

Sun, 03 January 2016 07:39

cleverwat
Messages: 6
Registered: January 2016

Junior Member

If yes how can I change it when running the script?

Report message to a moderator

Is there a difference between procedure successfully completed and anonymous block competed? [message #646510 is a reply to message #646508]

Sun, 03 January 2016 07:39

cleverwat
Messages: 6
Registered: January 2016

Junior Member

If yes how can I change it when running the script?

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646511 is a reply to message #646508]

Sun, 03 January 2016 08:41

Michel Cadot
Messages: 67639
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This question is completely not understandable.
Even posted 3 times.

Explain you question.

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646513 is a reply to message #646511]

Sun, 03 January 2016 09:04

cleverwat
Messages: 6
Registered: January 2016

Junior Member

Michel Cadot wrote on Sun, 03 January 2016 08:41

This question is completely not understandable.
Even posted 3 times.

Explain you question.

When I run the script on my personal computer in the oracle sqldeveloper, it shows the output and message"procedure successfully completed". However, when I run it on computer at work it shows the output but the message is "anonymous block complited". So my question is "Do I need to change the settings, so it can show me "anonymous block completed" on my computer or these messages don't affect my script's functions?"

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646514 is a reply to message #646513]

Sun, 03 January 2016 09:16

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Different tools report procedure completion using different words.

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646515 is a reply to message #646513]

Sun, 03 January 2016 10:11

Michel Cadot
Messages: 67639
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Message depends on the tool and is not a SQL thing.
My own tool will report "done in x.xxx s" whatever is the SQL statement you ask it to execute.

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646517 is a reply to message #646515]

Sun, 03 January 2016 14:25

cleverwat
Messages: 6
Registered: January 2016

Junior Member

Michel Cadot wrote on Sun, 03 January 2016 10:11

Message depends on the tool and is not a SQL thing.
My own tool will report "done in x.xxx s" whatever is the SQL statement you ask it to execute.

So nobody would make this as a problem if I show them my project with this message?

[Updated on: Sun, 03 January 2016 14:26]

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646518 is a reply to message #646517]

Sun, 03 January 2016 15:54

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

As long as it works successfully, it won't be a problem. Of course it it doesn't work successfully it will a problem.

And it might even work not successfully, even if the client tool reports "successfully completed". (for example if you caught and disregarded exceptions in an exception handler in your code)

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646535 is a reply to message #646517]

Mon, 04 January 2016 02:02

Michel Cadot
Messages: 67639
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

cleverwat wrote on Sun, 03 January 2016 21:25

So nobody would make this as a problem if I show them my project with this message?

It is a problem if the specifications of your project says you have to return another message or no message at all.
What do your specifications say?

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646573 is a reply to message #646535]

Mon, 04 January 2016 11:49

cleverwat
Messages: 6
Registered: January 2016

Junior Member

there is no specification actually

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646574 is a reply to message #646573]

Mon, 04 January 2016 11:59

Michel Cadot
Messages: 67639
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So any answer is correct.

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646575 is a reply to message #646573]

Mon, 04 January 2016 12:20

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

cleverwat wrote on Mon, 04 January 2016 18:49

there is no specification actually

Soooo...... Basically.............

When they tell you to "show your project" can't you just ask "What Project?", since there doesn't seem to be a project?

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646606 is a reply to message #646517]

Tue, 05 January 2016 07:03

EdStevens
Messages: 1292
Registered: September 2013

Senior Member

cleverwat wrote on Sun, 03 January 2016 14:25

So nobody would make this as a problem if I show them my project with this message?

Wouldn't that be something you'd have to ask the people to whom you show the message? How would a stranger on the internet (the members of this forum) know what your own managers expect?

Report message to a moderator

Re: Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646608 is a reply to message #646573]

Tue, 05 January 2016 07:37

gazzag
Messages: 1091
Registered: November 2010
Location: Bedwas, UK

Senior Member

Not even expected output?

Report message to a moderator

Previous Topic:	[SQL*Plus] SET SECUREDCOL
Next Topic:	To call SQL script based on date range

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 15 12:53:24 CST 2021