OraFAQ Forum: Forms » While Calling a Function from Form its giving Error.

Home » Developer & Programmer » Forms » While Calling a Function from Form its giving Error.

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

While Calling a Function from Form its giving Error. [message #86578]

Tue, 12 October 2004 22:04

M Kumar
Messages: 38
Registered: August 2004

Member

I had created a function in backend
-----------------------------------
create or replace function day_value(dno number,ddt date,ecd varchar2)
return varchar2 is
dval varchar2(3);
stat varchar2(500);
begin
stat:='select day'||dno|| 'from tshiftrot where empcd='||ecd||'and schdate='||ddt;
execute immediate stat into dval;
return dval;
end;
/
In Form6i while i am calling it inside a procedure its giving error
------------------------------------------------------
PROCEDURE SHIFT_PROC IS
D1 varchar2(3);
BEGIN
D1:=DAY_VALUE(28,:pdate,'1354');
message(d1);
END;

Error:Identifier 'DAY_VALUE' must be declared

Pl. can anyone help me.

Thanks

Report message to a moderator

Re: While Calling a Function from Form its giving Error. [message #86609 is a reply to message #86578]

Wed, 13 October 2004 22:09

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

If you have created the finction in backend then
do like this

1. PROCEDURE SHIFT_PROC IS
D1 varchar2(3);
BEGIN
select DAY_VALUE(28,:pdate,'1354')
into D1
from dual;
message(d1);
END;

2. If function is in some other login then give
the user_name.function_name ...

This will solve your problem.

Chao
Atul P

Report message to a moderator

Previous Topic:	Pop Up Screen
Next Topic:	Maximum no of fields in a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 15:12:52 CDT 2024