OraFAQ Forum: Forms » how can pass a parameter to function at run time in oracle 10g developer

Home » Developer & Programmer » Forms » how can pass a parameter to function at run time in oracle 10g developer

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

how can pass a parameter to function at run time in oracle 10g developer [message #235897]

Tue, 08 May 2007 05:44

habib.khan
Messages: 20
Registered: March 2007
Location: Islamabad

Junior Member

hi every body,
i am using oracle 10g and i want to pass empno to a function as a parameter at run time,an input box appear,user enter empno and function use this empno to return employee salary.
my get salary function is as below.
FUNCTION get_salary(eno number) RETURN number IS
salary number(10);
BEGIN
select sal into salary from emp where empno=eno;
return salary;
END;

please help me how can solve this problem.
thanks in advance.
Muhammad Habib

[Updated on: Tue, 08 May 2007 06:03]

Report message to a moderator

Re: how can pass a parameter to function at run time in oracle 10g developer [message #235910 is a reply to message #235897]

Tue, 08 May 2007 06:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You'd do that as usual ...

:block.item := get_salary(:block.eno);

Put it into an appropriate trigger.

Report message to a moderator

Re: how can pass a parameter to function at run time in oracle 10g developer [message #236233 is a reply to message #235897]

Wed, 09 May 2007 06:41

shankar muthusamy
Messages: 21
Registered: November 2006
Location: singapore

Junior Member

pls explain your question clearly, where is ur function, wht u mean by run time and wht u trying to do

Report message to a moderator

Re: how can pass a parameter to function at run time in oracle 10g developer [message #236360 is a reply to message #236233]

Wed, 09 May 2007 13:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@shankar muthusamy, write in English, please. pls, ur, wht and similar are not to be used on the OraFAQ Forum.

Report message to a moderator

Re: how can pass a parameter to function at run time in oracle 10g developer [message #236402 is a reply to message #236360]

Wed, 09 May 2007 21:09

shankar muthusamy
Messages: 21
Registered: November 2006
Location: singapore

Junior Member

ok sorry for writing like that

Report message to a moderator

Previous Topic:	Query condition
Next Topic:	commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 06:25:47 CDT 2025