Home » SQL & PL/SQL » SQL & PL/SQL » Functions call other function.
Functions call other function. [message #240032] Thu, 24 May 2007 00:07 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear Friends,

My oracle Version is 10g.

I calling a function from sql select same time function body contain DML statement,that time is possible call function from sql?

and again one,

same function containing DML statement call other function or procedures is possible call other functions or procedures ?


Expecting Your replies..

Arun..



Re: Functions call other function. [message #240034 is a reply to message #240032] Thu, 24 May 2007 00:13 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,


Quote:

I calling a function from sql select same time function body contain DML statement,that time is possible call function from sql?

and again one,

same function containing DML statement call other function or procedures is possible call other functions or procedures ?



i did not understand what you want.
can you show us the function or how you are trying to call the function. or what you want to do?, with an example or so.

regards
shanth

[Updated on: Thu, 24 May 2007 00:13]

Report message to a moderator

Re: Functions call other function. [message #240043 is a reply to message #240032] Thu, 24 May 2007 00:35 Go to previous messageGo to next message
breddypatil
Messages: 4
Registered: May 2007
Location: Bangalore
Junior Member
Arun,

please mention your doubt clearly.
I am not getting what you really want.
Re: Functions call other function. [message #240049 is a reply to message #240032] Thu, 24 May 2007 00:45 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

ok wait..
Re: Functions call other function. [message #240065 is a reply to message #240049] Thu, 24 May 2007 01:16 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Arun, we can repeat ourselves over and over and over and over again: "try and see what happens".

Hint: ORA-14551 is around the corner.

http://www.orafaq.com/forum/fa/448/0/


And I can repeat myself over and over and over and over again: closed.

MHE
Previous Topic: Call a function pipelined with paramert from report
Next Topic: Create Table T1 with column name "select".
Goto Forum:
  


Current Time: Tue Dec 06 12:01:54 CST 2016

Total time taken to generate the page: 0.09921 seconds