OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » STNDRD20.OLB

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

STNDRD20.OLB [message #17909]

Thu, 03 February 2005 22:54

Riaz
Messages: 112
Registered: February 2002

Senior Member

hi..please let me know where can I find STNDRD20.OLB and PL/SQL library CALENDAR.PLL.
I need it urgenly to download
thanks in advance
Riaz

Report message to a moderator

Re: STNDRD20.OLB [message #17910 is a reply to message #17909]

Thu, 03 February 2005 23:31

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What version of Forms are you using?

MHE

Report message to a moderator

Re: STNDRD20.OLB [message #17911 is a reply to message #17910]

Fri, 04 February 2005 00:13

Riaz
Messages: 112
Registered: February 2002

Senior Member

forms6i, win2k
Please
Riaz

Report message to a moderator

Re: STNDRD20.OLB [message #17913 is a reply to message #17911]

Fri, 04 February 2005 00:33

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Ok, they come on a separate CD of your Forms6i installation. If you don't have it, don't worry. They're available online too. Here's a direct link. You'll need a free OTN account in order to get this.

MHE

Report message to a moderator

Re: STNDRD20.OLB [message #17914 is a reply to message #17913]

Fri, 04 February 2005 00:39

Riaz
Messages: 112
Registered: February 2002

Senior Member

I am really thankful to you. I will turn to you latter if i need help again.thanks
Riaz

Report message to a moderator

Re: problem with STNDRD20.OLB [message #17958 is a reply to message #17914]

Sun, 06 February 2005 19:47

Riaz
Messages: 112
Registered: February 2002

Senior Member

hi..I am unable to understand the parameters passed to the following procedure.
when i compile it, it give an error eg Invalid no of arguments in call. please help

DATE_LOV.GET_DATE
(NVL(:BLOCK.ITEM, SYSDATE),
'BLOCK.ITEM',
200, 100,
'SELECT DATE',
'OK','CANCEL',
TRUE, FALSE, FALSE);

Report message to a moderator

Re: problem with STNDRD20.OLB [message #17962 is a reply to message #17958]

Sun, 06 February 2005 21:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

This is the definition of the DATE_LOV.GET_DATE procedure:

procedure get_date
         ( display_date  in date
         , return_item   in varchar2
         , v_x_pos       in number   := 0
         , v_y_pos       in number   := 0,
         , v_title       in varchar2 := 'Date List of Values'
         , v_ok          in varchar2 := 'OK'
         , v_cancel      in varchar2 := 'Cancel'
         , v_highlight   in boolean  := TRUE
         , v_autoconfirm in boolean  := FALSE
         , v_autoskip    in boolean  := FALSE);

Your number of parameters seems correct, but are you sure that in this expression

NVL(:BLOCK.ITEM, SYSDATE)

block.item is a date? Wrap it in a TO_DATE and see what it does...

MHE

Report message to a moderator

Re: problem with STNDRD20.OLB [message #17973 is a reply to message #17962]

Mon, 07 February 2005 01:16

Riaz
Messages: 112
Registered: February 2002

Senior Member

Thank you for in-time help. i simply left out the function NVL and it worked fine. thanks for being here....
Riaz

Report message to a moderator

Previous Topic:	alter table question
Next Topic:	Bind varaible continuation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 05 06:37:45 CDT 2026