>Ok, my bad then. :)
>
>----------
>
>NO, Oracle
>
>Flemming
>
>
>>I guess I'm a bit lost, are you running Microsoft SQL Server 6.5? I did
>>assume that you were, and if that's the case and Oracle claims to support
>>that installation, then it is their problem and they do need to comply
with
>>Microsoft's format because that's what they are supporting. If I claim
>>that my ActiveX plugin supports Citrix clients, then well, I have to
>>support Citrix, not ANSI. Maybe Dale can shed some light here since he's
>>been working with RadiusNT and Oracle lately????
>>
>>So, Are you running Microsoft SQL Server <>6.5?
>>
>>At 02:51 PM 1/28/98 +0100, you wrote:
>>>Sorry BUT
>>>
>>>Oracle clames that this is a MS standard, and NOT ANSI standard.
>>>In Oracle is it not possible to create functions with "NULL parameter
()".
>>>It is possible to create a "GetDate" function, but it must be called
>without
>>>"()",
>>>SELECT GETDATE, will then return the right value.
>>>
>>>I think I have a BIG problem here.
>>>
>>>Flemming
>>>
>>>
>>>
>>>>They told you that isn't standard SQL? If you are talking about "SELECT
>>>>GETDATE()," it's standard where I come from! Now, if you try a
statement
>>>>just as "GETDATE()," that will most likely fail because SQL doesn't
>>>>understand GETDATE without SELECT or some other Action identifier. In
>fact,
>>>>I'll check the SQL book right now! Alrighty, Oracle is not correct...I
>>>>don't see how they can claim to support SQL if they don't know SQL's
>>>>requirements! Here's what it says in the SQL Server 6.5 Developer Book:
>>>>
>>>>GETDATE
>>>>The GETDATE function produces the current date and time in SQL Server
>>>>Internal format for datetime values. GETDATE takes the NULL parameter
>().
>>>>
>>>>To find the current system date and time:
>>>>
>>>>SELECT GETDATE()
>>>>
>>>>----------------------------------------------
>>>>July 29 1995 2:50 PM
>>>>
>>>>And so on....It says it "takes the null parameter ()," which in my
>>>>understanding of most of the SQL books, *needs* to be there to be fully
>>>>compatible. Oracle customer support is wrong in this case, don't ya
>think?
>>>>:) I apologize if I sound a bit heated, it's a been a comparable day
>with
>>>>a couple other companies.
>>>>
>>>>----------
>>>>From: Flemming Eriksen
>>>>Sent: Wednesday, January 28, 1998 2:57 AM
>>>>To: RadiusNT@iea-software.com
>>>>Subject: Re: RadiusNt with Oracle
>>>>
>>>>Options Registry ?
>>>>
>>>>Oracle is running on a Unix Server, RadiusNT access Oracle thrue
>>>>ODBC/SQL*Net.
>>>>Oracle Customer Support telling me that "GetDate()" is not Standard SQL
>>>>(ISO??)
>>>>Is it possible to change RadiusNT's "GetDate()" to "GetDate" ?
>>>>
>>>>Flemming
>>>>
>>>>
>>>>>Flemming Eriksen wrote:
>>>>>>
>>>>>> I am about to convert access database to Oracle, but inserting into
>>>>CALLS
>>>>is
>>>>>> not possible.
>>>>>> The problem is access use "GetDate()" and in Oracle I can't create a
>>>>>> function that dosn't have a value inside "()".
>>>>>>
>>>>>> Do somebody have know what to do?
>>>>>
>>>>>You can add 16 to the Options Registry entry to have it act
>>>>>like MS Access. I've been playing around with Oracle here and
>>>>>trying to get RadiusNT to work with in (albeit 2.5). If people
>>>>>think MS SQL Server is difficult to understand, they should
>>>>>run from Oracle. Now I know what Oracle Admins get big bucks! :)
>>>>>
>>>>>--
>>>>>Dale E. Reed Jr. (daler@iea.com)
>>>>>_________________________________________________________________
>>>>> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
>>>>> Internet Solutions for Today | http://www.iea-software.com
>>>>>
>>>>> ----------------------------------------------------------
>>>>> RadiusNT Mailing List lists@iea-software.com
>>>>>
>>>>
>>>>
>>>> ----------------------------------------------------------
>>>> RadiusNT Mailing List lists@iea-software.com
>>>>
>>>>
>>>>
>>>
>>>
>>> ----------------------------------------------------------
>>> RadiusNT Mailing List lists@iea-software.com
>>>
>>>
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>>
>
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>
>