RE: RadiusNt with Oracle

Mitch Wagers ( mwagers@ocsnet.net )
Wed, 28 Jan 1998 03:58:48 -0800

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

begin 600 WINMAIL.DAT
M>)\^(C$+`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
MD 8`. $```$````,`````P``, (````+``\.``````(!_P\!````40``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````%)A9&EU<TY40&EE82US;V9T=V%R92YC
M;VT`4TU44 !2861I=7-.5$!I96$M<V]F='=A<F4N8V]M`````!X``C !````
M!0```%--5% `````'@`#, $````:````4F%D:75S3E1 :65A+7-O9G1W87)E
M+F-O;0````,`%0P!`````P#^#P8````>``$P`0```!P````G4F%D:75S3E1
M:65A+7-O9G1W87)E+F-O;2<``@$+, $````?````4TU44#I2041)55-.5$!)
M14$M4T]&5%=!4D4N0T]-```#```Y``````L`0#H!`````@'V#P$````$````
M`````A8]`02 `0`9````4D4Z(%)A9&EU<TYT('=I=&@@3W)A8VQE`&T(`06
M`P`.````S@<!`!P``P`Z`# ``P!B`0$@@ ,`#@```,X'`0`<``,`+P`9``,`
M0 $!"8 !`"$````U.4(W-S0Y,T$W.3=$,3$Q03,U-S P-C P.#%#1D4U-0#T
M!@$#D 8`P @``!0````+`",```````,`)@``````"P`I```````#`"X`````
M``,`-@``````0 `Y`*#/<A?D*[T!'@!P``$````9````4D4Z(%)A9&EU<TYT
M('=I=&@@3W)A8VQE``````(!<0`!````%@````&]*^07:9-TMUJ7IQ'1HU<`
M8 @<_E4``!X`'@P!````!0```%--5% `````'@`?# $````3````;7=A9V5R
M<T!O8W-N970N;F5T```#``80:E^6_0,`!Q##!P``'@`($ $```!E````5$A%
M651/3$193U542$%425-.5%-404Y$05)$4U%,/TE&64]505)%5$%,2TE.1T%"
M3U54(E-%3$5#5$=%5$1!5$4H*2PB25134U1!3D1!4D172$5214E#3TU%1E)/
M34Y/5RQ)1@`````"`0D0`0```#('```N!P``Z T``$Q:1G7Y"54J_P`*`0\"
M%0*D`^0%ZP*#`% 3`U0"`&-H"L!S973N,@8`!L,"@S(#Q@<3`H,B,P]Z:&5L
M`R!$;.IG`H,T$PU]"H (SPG9XCL7GS(U-0* "H$-L<$+8&YG,3 S%" +"DL2
M\@P!8P! (%04\'G$('0&\&0@>0A@',"G$< %0 0`;B<%0',!D QN9 L1!@!1
M3#\@V"!)9AT3"L!E', '0%IK"X!G'V &X'4%0"(`4T5,14-4($<`151$051%
M*"ED+"(=H'0G!" >%W>S%/ ?@4D@!: '@" #4L(A'N!.;W<L': ?%)1T<ARP
M81X"=&4'@'$","!J=1X0'V $("(_(1H=8P/P%1$$8"71;&FV:Q4`'+!F"W #
M(&(%D(YA)< ?D!ZA(&1O!Y#]'=)U'D $D!X3(08G01U@UR!2(*4%L7,C0F\=
M8 20\1-P8W1I`B =H VP`C#[!I (D2X>\ .@*& M`"0@W$DG%1$1L 60:QU1
M*11-!N!O+T %$&=H!4!N4R0`(\%!;# S>20@3_IR`-!L'Y $`#"!!4 %H?L7
MH"T`+C+@(Q I<!W3">#^("M0!^ LH1RP*- #H#' C0MP;1S!'@!U<' 70>\I
M(R1!-!,S-&LPD1Z2(?&Q%Z!Q=6D7H"5B<R/!/D@BT2'Q(K =@AWQ87DO!" +
M@"]7!F%V+,$V+EHU%3!E.I 7,' LP4+]+_$Z"H4*A2$5"H4<@2J7%F8I\"T$
M< -@9'5C^P>1+V)C"' 7H"6!'E E0/\?8"IQ+1 C43FQ.BDN("5 _P2@!T C
M< 6P`, %0$*Q0%/M0/-V!T *4',N`"J7`9!C*! _A$Y53"E0"K%AJP> 0D$@
M(8 N/ Q4-1#W+<! PC^Y<SF )4% 7#O]>R"N/ PM3/].#T[)"H5*`G4H,3(Y
M(#$Y.68U#()0@#HU#?!1$E"Z33P,02IQ+$ L`&XRX>\S`#E&('%%"&Y04 ,@
M1?K;(:$BL&D1L#FB;1RP*?B]'_)O'Q GHU?Q+VIS)"#$*FX)X&1S*C3R*+#_
M+U(?@EHC/H 5$#1!`W *L/LM$ )@9411,94_X!X0(T'W+"$U13(!=P-@( $Y
MLS(!;RC0$? D(#,T>23P7J%N\FL>T#HI'N$?8#5@%S#X9VEZ,>$?$",0+$ I
M\=TDX6(Y,13P)3%D)"$AXO]B`0GA).%;DS&@7 % 41RP_RLB8Y,U0#'1+)1;
MDP,`1#%'/ P*]"?P,3@P`M%IT"TQ-#11@7AH<PM9_#$V"J #8"5 +0!,Z0J'
MUVE+##!J%D8#83IKGFH6I5$#1C'0;6T?\D4%$/]94 GP:S]L309@`C!M?VZ+
MME<)@%F@<V1Q)"!*`'"V=0K 4'$X)"!0P3A10OXW$W!1]G#/:A9'H'*?;HN,
M4F%7H"7 3E1 ")"L82TL0 & =Q]Q+B,QXW:O<6YU8FHRL7C/>=Q_2A!ZEB<R
M9-$QE&:?9Z,SWC9I%Q7"# %J%D\%,"TAWP0@@(!A`!X0),$_/ PQF%YR*? #
M`%?"8X)5`P!X[SI5)"!ZIA]@8S]A!" QE0<=8(>@@?9/1$)#+]T>H2H'P#+0
MAIQ#7.9^,/\U5"5 %1 ?\B-1'6,F,!(`WD0E,2& (;$R%%,>*0J%0"A)4T\_
M/TP&2?]4$S5@!!!;\C3R$;$:H!^0_WJF(?&/.C4!CS8AL(8=;U9[/ P*A3YO
M7EX")4 []C[^/IJ'8((TX" TDV("(#J1_R7AB>1 80&@7P$T\C&4)"#^8B!A
M"X 1\ `@'_(+@#4!]$-!1<!3"H4$`)L8,C+_DM9&MIN!/<(_$5P!-. R`?^)
MU2CRCSHJ8CFQ,94C$0!P_QWA!0!B<A]@FQ@^AQUC*7#_'<,1P#J0).%#\Y[R
M+6$@@'>/L:(XFQA$-1$C00;@9/\<L*D3-M,XXS4!*7"&%IL'_ED=,31B>K =
M`&G@-/(O8O^%#R5Q),$U`:D3.3$N89B6_R?R!=(L\(GR1%$NL*DQ8U/]"U%Y
M'_,#8&'"@5EB41^!_QXQF)8DL1_R-0&3T 5 B4>]-0%W!; O0&2S.;$H!T#[
M*+ Y,3(ZX$:@'N,[<#M@_X'GMV!?\@73.C@R`5>@#="_5G!04)Q#*?@D(#03
M<RM1_QSPF):'H2-S,85$42/Q(P'SK.@QE4%D;Y$$(+@28B!_(!">P"\P.#%@
M4*WN3[<^^X]P,=%%+@" @ F 4# M\7=&@!Y0,=!R>R)[\L077W_(7\EORG_+
M6YB6'N#,XTG\14$&`'N%+I$^H$11S.+N?![@>J8D($5=(0= 8K'C*F*)H49!
M4:#'0A6X(?_-D I A21#(D>@9'+.PC/ 00) <#HO+W?4`"[_>S^M_4SOUT_8
M7T]=FY")1_9-*'$?\DR%L<SEV]8G\/T>$'-[+ZWM/ S63^#_X@__3UW:?]N/
MW)][O8)_:1<U1=J%@J%%L$`ZW ```,`$! ``````P`1$ ````! ``<P\#QQ
M@.(KO0% ``@P\#QQ@.(KO0$>`#T``0````4```!213H@``````,`#33]-P``
"]N,K
`
end