OraFAQ Forum: Forms » how can i use this (numtodsinterval)

Home » Developer & Programmer » Forms » how can i use this (numtodsinterval)

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

how can i use this (numtodsinterval) [message #534202]

Sun, 04 December 2011 07:18

windowsdos
Messages: 29
Registered: May 2011

Junior Member

how can i use this (numtodsinterval) in oracle developer 2.1
(forms)

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534203 is a reply to message #534202]

Sun, 04 December 2011 08:14

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

Senior Member
Account Moderator

Certain features that are available in the database sometimes don't work in Forms (especially your really ancient version). If you can't make it work in a form (by the way, what error did you get when you tried to use it?), you could try to create a stored procedure (or a function). Parameters would be the same that NUMTODSINTERVAL expects; you'd then pass these parameters to NUMTODSINTEVAL and return your own stored function's result to a form. Of course, you have to make sure that NUMTODSINTERVAL works in your database. If not, I'm afraid you are rather helpless (apart from creating your own "numtodsinteval" function).

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534215 is a reply to message #534203]

Sun, 04 December 2011 10:11

windowsdos
Messages: 29
Registered: May 2011

Junior Member

it's worked well with my database
but it is an error when put it in the forms

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534217 is a reply to message #534215]

Sun, 04 December 2011 10:44

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So as littlefoot said, create your own function covering numtodsinterval one.

Regards
Michel

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534218 is a reply to message #534217]

Sun, 04 December 2011 10:49

windowsdos
Messages: 29
Registered: May 2011

Junior Member

how can i do that
can u help me

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534220 is a reply to message #534218]

Sun, 04 December 2011 11:50

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SQL> create or replace function mynumtodsinterval (p_n in integer, p_unit in varchar2)
  2  return INTERVAL DAY TO SECOND 
  3  is
  4  begin
  5    return numtodsinterval (p_n, p_unit);
  6  end;
  7  /

Function created.

SQL> select mynumtodsinterval(1,'MINUTE') from dual;
MYNUMTODSINTERVAL(1,'MINUTE')
---------------------------------------------------------------------------
+000000000 00:01:00.000000000

1 row selected.

Regards
Michel

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534324 is a reply to message #534220]

Mon, 05 December 2011 06:00

windowsdos
Messages: 29
Registered: May 2011

Junior Member

please how can i use this function in forms 2...1

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534325 is a reply to message #534324]

Mon, 05 December 2011 06:06

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

Same way you would use any other function

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534328 is a reply to message #534325]

Mon, 05 December 2011 06:21

windowsdos
Messages: 29
Registered: May 2011

Junior Member

okay can u see me the way
ican't reach it

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534338 is a reply to message #534328]

Mon, 05 December 2011 06:47

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

variable := mynumtodsinterval (p_n, p_unit);

Is how you would do it in forms 6i and later.
I assume you do the same in forms 2.1 but it's so old I can't be sure.

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534365 is a reply to message #534338]

Mon, 05 December 2011 10:12

windowsdos
Messages: 29
Registered: May 2011

Junior Member

okay

but can u do the function to me
and how can i use it in the calling

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534367 is a reply to message #534365]

Mon, 05 December 2011 10:20

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

I really don't understand what your issue is.
Michel has given sample code for the function.
I've shown you how to call it.
What exactly do you not understand?

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534477 is a reply to message #534338]

Tue, 06 December 2011 08:59

windowsdos
Messages: 29
Registered: May 2011

Junior Member

cookiemonster wrote on Mon, 05 December 2011 14:47

variable := mynumtodsinterval (p_n, p_unit);
Is how you would do it in forms 6i and later.
I assume you do the same in forms 2.1 but it's so old I can't be sure.

ok can i equal between 1 variable
with function return 2 values

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534486 is a reply to message #534477]

Tue, 06 December 2011 09:44

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

windowsdos wrote on Tue, 06 December 2011 14:59

ok can i equal between 1 variable

I have no idea what that means.

windowsdos wrote on Tue, 06 December 2011 14:59

with function return 2 values

If you want to use multiple values you would probably be better off using a procedure.

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534492 is a reply to message #534486]

Tue, 06 December 2011 10:30

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

Senior Member
Account Moderator

... with two OUT parameters.

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534497 is a reply to message #534486]

Tue, 06 December 2011 12:33

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

cookiemonster wrote on Tue, 06 December 2011 10:44

windowsdos wrote on Tue, 06 December 2011 14:59

with function return 2 values

If you want to use multiple values you would probably be better off using a procedure.

And what 2 values would you be returning anyway?

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534498 is a reply to message #534497]

Tue, 06 December 2011 13:07

windowsdos
Messages: 29
Registered: May 2011

Junior Member

i mean

he wrote variable := mynumtodsinterval (p_n, p_unit);
what is this statment mean

i already create the function take and return wsith two parameter

Report message to a moderator

Re: how can i use this (numtodsinterval) [message #534501 is a reply to message #534498]

Tue, 06 December 2011 14:10

cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester

Senior Member

windowsdos wrote on Tue, 06 December 2011 19:07

he wrote variable := mynumtodsinterval (p_n, p_unit);
what is this statment mean

That's an example of how to call a function. Variable set equal to function with parameters. If you can't understand that then you need to spend some time reading up on the basics.
I suggest you start with the Database Application Developer's Guide - Fundamentals

The full oracle documentation set can be found here

I also strongly suggest you get rid of forms 2.1 and replace it with something created this century. 10g or 11g forms.

Report message to a moderator

Previous Topic:	When timer expires Oracle forms (3 Merged)
Next Topic:	parametrized cursor in oracle form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 15 17:57:59 CDT 2024