OraFAQ Forum: Forms » Functions/procedure in Library

Home » Developer & Programmer » Forms » Functions/procedure in Library

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

Functions/procedure in Library [message #84950]

Thu, 13 May 2004 20:48

Ali
Messages: 88
Registered: March 2000

Member

how to create a function/procedure in a
library and how to use this from that library
wht is the scope of that fn.

Report message to a moderator

Re: Functions/procedure in Library [message #84962 is a reply to message #84950]

Sat, 15 May 2004 01:39

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Ali,
Simply open your Form Builder.
Go to node Pl/Sql Libraries.
From File Select New - > PL/Sql Library
A book type of Icon with Name Lib_001 or some number will be created in Object Navigator.
Now Pres on Program Units and Start creating your Procedures/Functions or packages.
When you are done Compile them and save the file.It will be saved as PLL file.
In order to hide your code I recommend to create Packages in PLL.

Regards
Himanshu

Report message to a moderator

Re: Functions/procedure in Library [message #85027 is a reply to message #84950]

Mon, 24 May 2004 03:44

Anupam
Messages: 62
Registered: July 2001

Member

select the pl/sql libraries and click create and click on program units and name the program unit and choose the option for function/procedure/package.

and write the code

and for referencing that program units of that library
just write

library_name.program_unit_name(argument);

u can reference that program unit from anywhere.

jope it ll help u

Report message to a moderator

Re: Functions/procedure in Library [message #85587 is a reply to message #85027]

Sun, 11 July 2004 06:45

Essien D. Essien
Messages: 1
Registered: July 2004

Junior Member

Please kindly send the funtions ;f a library to me please.

Report message to a moderator

Previous Topic:	Doubt in sql
Next Topic:	Reg: windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 13:22:14 CDT 2024