Hi Arran,
Thanks for your reply.... have created stored procedure(myS1Request) in oracle
database 11g as shown below, procedure takes input and output parameters.
The below procedure should be called in the SQL module in Free-radius for
Authentication and Authorization purpose.
PROCEDURE myS1Request(
UserName IN VARCHAR2,
MessageType IN LONG,
RemoteAddress IN LONG,
FemtoAp IN VARCHAR2,
RadCoverageInd IN LONG,
RadCellId IN LONG,
Rad3GCellId IN LONG,
RadGeoCord IN LONG,
RadAltDirection IN LONG,
HNBIPAddress IN LONG,
RadPLMNId IN LONG,
HNBCellIdentity IN LONG,
RadLocAreaLAC IN LONG,
RadRoutAreaCode IN LONG,
RadServiceArCode IN LONG,
RadCSGId IN LONG,
RadUECap IN LONG,
Result OUT VARCHAR2,
RadRegRejCau OUT LONG,
RadLocBlacklInd OUT LONG,
HNBCellId OUT LONG,
RadServiceAreaC OUT LONG,
RadLocationAreaI OUT LONG,
RadRoutAreaC OUT LONG
)
please help me how can proceed...........
.
Lakshmi narayana | Prod Engineering | Tech Mahindra
#9/7 Hosur Road,Bangalore-560029
/Office: +91 80 40243000, Extn: 3486
| Mobile: +91 9060867386
Email:lb0074...@techmahindra.com
www.techmahindra.com
Message: 2
Date: Tue, 15 Jan 2013 10:46:08 +0000
From: Arran Cudbard-Bell <a.cudba...@freeradius.org>
To: FreeRadius users mailing list
<freeradius-users@lists.freeradius.org>
Subject: Re: how to call stored procedure with output varaibles in
free-radius
Message-ID: <c47f1ee1-3524-4709-85fa-79d0b268c...@freeradius.org>
Content-Type: text/plain; charset=us-ascii
On 15 Jan 2013, at 06:22, "Lakshmi Narayana Baliah"
<lb0074...@techmahindra.com> wrote:
> Hi All,
>
> How to call my own stored procedure ,which takes input and output variable in
> free-radius server.
>
> How do i do that ??? please help....................
Guessing you're referring to stored procedures in SQL? Or are you misusing SQL
terminology to refer to something like a subroutine or function writen in the
policy language?
-Arran
------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
End of Freeradius-Users Digest, Vol 93, Issue 42
************************************************
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary
and confidential and subject to the
Tech Mahindra policy statement, you may review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahindra.com/Disclaimer.html</a>
externally and <a
href="http://tim.techmahindra.com/tim/disclaimer.html";>http://tim.techmahindra.com/tim/disclaimer.html</a>
internally within Tech Mahindra.
============================================================================================================================
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
