Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL (PL/SQL)
PL/SQL [message #305615] Tue, 11 March 2008 06:34 Go to next message
satishreddyj
Messages: 3
Registered: March 2008
Location: chennai
Junior Member
I have one doubt about the difference between dbms_output and raise_application_error.

[Mod-edit: Frank removed POLL-indicator]

[Updated on: Tue, 11 March 2008 07:26] by Moderator

Report message to a moderator

Re: PL/SQL [message #305616 is a reply to message #305615] Tue, 11 March 2008 06:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Only one doubt?

Given that they do completely different things - one logs a message to the Dbms_Output package, and the other raises a user defined execption and halts normal program execution, I must assume that your 'doubt' is 'What are these things?'

Also, why did you create this as a poll rather than a normal topic?
Re: PL/SQL [message #305618 is a reply to message #305615] Tue, 11 March 2008 06:43 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
dbms_output is used to display the output from your Pl/Sql block and raise_application_error is used to stop the execution of the block when it encounters an error and it rollbacks the work done.


regards,
Re: PL/SQL [message #305619 is a reply to message #305615] Tue, 11 March 2008 06:43 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search search search in the oracle pl/sql reference manual.

Regards

Raj
Previous Topic: mutiple adress intable
Next Topic: SQL QUERY - please (merged)
Goto Forum:
  


Current Time: Tue Dec 06 10:45:17 CST 2016

Total time taken to generate the page: 0.13420 seconds