how to call stored procedure in free-radius server

[Phil Mayers]

On 15/01/13 11:30, Lakshmi Narayana Baliah wrote:
> 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.

>
> please help me how can proceed...........

Calling a stored procedure is the same as doing any other SQL query. You 
can either force the intput/output to match the radcheck/radreply schema 
using SQL, or use the SQL xlat syntax like so:

authorize {
   ...
   update request {
     Tmp-String-0 := "%{sql:select storedproc('%{Arg1}',...)}"
   }
   ...
}