OraFAQ Forum: Forms » How can I assign a value from pl/sql library

Home » Developer & Programmer » Forms » How can I assign a value from pl/sql library

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

How can I assign a value from pl/sql library [message #159420]

Sun, 19 February 2006 00:20

sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia

Junior Member

Hello,

How can I assign a value from pl/sql libaray to an item in the form.

Thanks

[Updated on: Sun, 19 February 2006 05:23]

Report message to a moderator

Re: How can I assign a value from pl/sql library [message #159478 is a reply to message #159420]

Mon, 20 February 2006 00:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You use the library functions and procedures the same way you would use PL/SQL functions and procedures.

David

Report message to a moderator

Re: How can I assign a value from pl/sql library [message #159533 is a reply to message #159478]

Mon, 20 February 2006 03:13

sd_md_faizan
Messages: 19
Registered: February 2006
Location: Saudi Arabia

Junior Member

EX.
In the form
item1 (display item)
for i in (select empno from emp) loop
:item1 := i.empno;
synchronize;
end loop;
In the pl/sql library.
for i in (select emp_no from emp) loop
-- how can assing the empno to 'item1' which is in the form.
end loop;
please give me one example.

Report message to a moderator

Re: How can I assign a value from pl/sql library [message #160248 is a reply to message #159478]

Fri, 24 February 2006 01:43

samidc
Messages: 35
Registered: February 2006

Member

Use Name_in or Copy buitin Function .

Thanks SaMiR.

Report message to a moderator

Previous Topic:	how to activate the zoom function
Next Topic:	how can I execute 'when button pressed' trigger at run time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:26:19 CDT 2024