Re: Oracle and stored procedure

2003-06-30 Thread randy
* HAUTZ Gilles [EMAIL PROTECTED] [2003-05-22 20:30]:
 Is it possible to call a stored procedure with freeradius and
 oracle?  If yes, how ?

you can use a function instead of a stored procedure - a function you
can call with select from freeradius.

hope this helps,
randy


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


RE: Oracle and stored procedure

2003-06-30 Thread Tim McCracken

Depending on what you are trying to do, Oracle stored procedures
can be called using triggers as well. Triggers are typically
executed on updates, deletes and inserts into tables.

I think (am not sure, because I've been out of the Oracle 
business for awhile) that version 9 allows triggers on
views that allow to update through a view. 

Tim

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of randy
 Sent: Monday, June 30, 2003 5:17 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Oracle and stored procedure
 
 
 * HAUTZ Gilles [EMAIL PROTECTED] [2003-05-22 20:30]:
  Is it possible to call a stored procedure with freeradius and
  oracle?  If yes, how ?
 
 you can use a function instead of a stored procedure - a function you
 can call with select from freeradius.
 
 hope this helps,
 randy
 
 
 - 
 List info/subscribe/unsubscribe? See 
 http://www.freeradius.org/list/users.html
 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html