Home » SQL & PL/SQL » Client Tools » Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) (sql)
Is there a difference between procedure successfully completed and anonymous block competed? (merged 3) [message #646508] Sun, 03 January 2016 07:38 Go to next message
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 Go to previous messageGo to next message
cleverwat
Messages: 6
Registered: January 2016
Junior Member
If yes how can I change it when running the script?
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 Go to previous messageGo to next message
cleverwat
Messages: 6
Registered: January 2016
Junior Member
If yes how can I change it when running the script?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Explain you question.
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 Go to previous messageGo to next message
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?"
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 Go to previous messageGo to next message
BlackSwan
Messages: 25793
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
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.

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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3205
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)
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
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?

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 Go to previous messageGo to next message
cleverwat
Messages: 6
Registered: January 2016
Junior Member
there is no specification actually
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So any answer is correct.

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 Go to previous messageGo to next message
ThomasG
Messages: 3205
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?
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 Go to previous messageGo to next message
EdStevens
Messages: 887
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?
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 Go to previous message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
Not even expected output?
Previous Topic: [SQL*Plus] SET SECUREDCOL
Next Topic: To call SQL script based on date range
Goto Forum:
  


Current Time: Wed Jan 17 14:58:47 CST 2018

Total time taken to generate the page: 0.03393 seconds