Home » SQL & PL/SQL » SQL & PL/SQL » Functions..
Functions.. [message #239665] Wed, 23 May 2007 00:39 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

I wrote one function.can u tell me..

this is correct? or not

create or replace function arun
return number
is
begin
insert into x values('java',322);
commit;
return 1;
end;
/

how can i call this function?

Regards,
Arun..

[Updated on: Wed, 23 May 2007 00:49]

Report message to a moderator

Re: Functions.. [message #239667 is a reply to message #239665] Wed, 23 May 2007 00:44 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
>I wrote one function.can u tell me..
>how can i call this procedure?
Please make up your/my mind.
Did you write a function or procedure?
What is the difference between the 2?
Can you spell PL/SQL?
Re: Functions.. [message #239670 is a reply to message #239665] Wed, 23 May 2007 00:50 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


ok now i edit ..
Re: Functions.. [message #239672 is a reply to message #239670] Wed, 23 May 2007 00:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Arun,

You were pointed to the manuals time and time again. Yet you return here asking the most basic of questions.
Please start reading a book or two about pl/sql. Believe me, you will _never_ learn pl/sql if you continue in this way..
Re: Functions.. [message #239679 is a reply to message #239672] Wed, 23 May 2007 01:15 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Arun, I sent you some PM to help you out but you did not reply. That's fine, but I'd read them again.

This thread is sad...and closed.

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

MHE
Previous Topic: Kindly help me out !!!
Next Topic: Is correct function..
Goto Forum:
  


Current Time: Fri Dec 02 12:25:45 CST 2016

Total time taken to generate the page: 0.07242 seconds