OraFAQ Forum: Forms » database function in forms

Home » Developer & Programmer » Forms » database function in forms

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

database function in forms [message #243667]

Fri, 08 June 2007 05:21

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

can anyone tell me that

how can i execute the database functions in forms 6i

mean if i want to use this select statement
select reverse(sysdate) from dual;
i can use it in sql prompt

but i want same statement to use in form s then how can i use it
when i use it on form it shows reverse to declare so we cannot use reverse function in form 6i?

Report message to a moderator

Re: database function in forms [message #243670 is a reply to message #243667]

Fri, 08 June 2007 05:34

sreepathi.das
Messages: 12
Registered: May 2007
Location: Cochin,Kerala

Junior Member

use this..

(variable or field with type,that of the return type of reverse()):=reverse(sysdate);

[Updated on: Fri, 08 June 2007 05:35]

Report message to a moderator

Re: database function in forms [message #243687 is a reply to message #243670]

Fri, 08 June 2007 07:33

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

thanks for replying but it shows
error 201
identifier'reverse'must be declared;

i had tried that first;

Report message to a moderator

Re: database function in forms [message #243894 is a reply to message #243687]

Sun, 10 June 2007 21:28

jamalfarooq
Messages: 35
Registered: August 2006

Member

hi,

hope this will work,

create function in database i am giving you an example.

Wrote file afiedt.buf

1 create or replace function test return varchar2
2 is
3 v_a varchar2(30);
4 begin
5 select reverse(sysdate) into v_a from dual;
6 return v_a;
7* end;
8 /

Function created.

then use this function on form.
like i tried it to create one text field and on button when_button_pressed wrote.

declare
v_a varchar2(30);
begin
:text3 := test;
end;

its work.

is that you want ?
if not let me know .. Cool

Thanks.

Jamal

Report message to a moderator

Re: database function in forms [message #243986 is a reply to message #243894]

Mon, 11 June 2007 03:12

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

yes that is the thing i want

thanks for replying & helping me

regards

ganesh

Report message to a moderator

Previous Topic:	how to change font on oracle forms
Next Topic:	Installation errors: Developer 2000 & Oracle on one machine (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 09:46:48 CDT 2025