Home » Developer & Programmer » Forms » database function in forms
database function in forms [message #243667] Fri, 08 June 2007 05:21 Go to next message
ganesh_jadhav0509
Messages: 63
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?


Re: database function in forms [message #243670 is a reply to message #243667] Fri, 08 June 2007 05:34 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

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

i had tried that first;
Re: database function in forms [message #243894 is a reply to message #243687] Sun, 10 June 2007 21:28 Go to previous messageGo to next message
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

Re: database function in forms [message #243986 is a reply to message #243894] Mon, 11 June 2007 03:12 Go to previous message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

yes that is the thing i want

thanks for replying & helping me

regards

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


Current Time: Sat Dec 10 05:00:21 CST 2016

Total time taken to generate the page: 0.23437 seconds