Home » SQL & PL/SQL » SQL & PL/SQL » Procedures and Functions (merged 6 BB and MC)
Procedures and Functions (merged 6 BB and MC) [message #377867] Fri, 26 December 2008 00:13 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Why we can't call functions with TCL statements from SQL statements?
Functions [message #377871 is a reply to message #377867] Fri, 26 December 2008 00:20 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Why we can't call functions that return Boolean value from SQL statements?Tell me reason?Please help me
Procedures [message #377874 is a reply to message #377867] Fri, 26 December 2008 00:24 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Why we can't call procedures from SQL statements?Tell me the reason?Please help me.
Procedures [message #377877 is a reply to message #377867] Fri, 26 December 2008 00:26 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Why we can't use return statement in procedues?Tell me the reason?Please help me
Re: Functions [message #377909 is a reply to message #377871] Fri, 26 December 2008 03:57 Go to previous messageGo to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
Boolean datatype exists in pl/sql but not in sql
Re: Functions [message #377916 is a reply to message #377867] Fri, 26 December 2008 04:32 Go to previous messageGo to next message
sathyam2627
Messages: 52
Registered: November 2006
Member

We cant use functions with OUT parameter in sql statements because there is no way for you to declare a variable in a SQL query and in order to call an IN OUT -- you need a local variable (to supply a value to be read from and to supply a place to put the out value into).
Procedures in SQL [message #379051 is a reply to message #377867] Sun, 04 January 2009 04:01 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Why we cannot call procedures in SQL statements?Give me the reason?Plese help me
Re: Procedures in SQL [message #379054 is a reply to message #379051] Sun, 04 January 2009 04:34 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
Because Procedure itself is a statement......It cannot be part of other statement.....It may be return a value or not whereas function always return a value.
Re: Procedures in SQL [message #379059 is a reply to message #379051] Sun, 04 January 2009 04:54 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You already asked this 5 times last week.
The answers are the same.

Regards
Michel
Previous Topic: Returning morethan one value from Procedure
Next Topic: Index
Goto Forum:
  


Current Time: Fri Dec 09 12:01:10 CST 2016

Total time taken to generate the page: 0.06579 seconds