Re: how to call stored procedure in free-radius server

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}',...)}" } ... }