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?

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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).

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You already asked this 5 times last week.
The answers are the same.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 01:26:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.