OraFAQ Forum: SQL & PL/SQL » Procedure in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » Procedure in oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Procedure in oracle [message #627663]

Thu, 13 November 2014 15:34

sanodani
Messages: 98
Registered: October 2014

Member

Hallo

How can i create a function (like. testfun), which takes two, IN PARAMETERS as Test1 and Test2 and this function returns type ref-cursor.
and when i call Test1 then will execute SELECT * FROM EMPLOYEES and Test2 will query the Employees table.
Smile

Report message to a moderator

Re: Procedure in oracle [message #627664 is a reply to message #627663]

Thu, 13 November 2014 15:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

HUH?

What datatype is TEST1 & TEST2?

>and when i call Test1 then will execute SELECT * FROM EMPLOYEES
why can not just do SELECT directly? What is purpose of this function?
how is below different from above?
>Test2 will query the Employees table.

Report message to a moderator

Re: Procedure in oracle [message #627670 is a reply to message #627663]

Fri, 14 November 2014 01:13

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

2 good books for you:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Report message to a moderator

Previous Topic:	sending mail using java in oracle PL/SQL 11g
Next Topic:	Question about tracing Web Applications SQL statements by using oracle AUDIT command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 16:38:15 CDT 2024