|
|
|
Free Dialup PL/SQL
I have the CARS procedures ready, so we can add the "Get a Free Dialup Account" to the FSUID.
There are two relavent PL/SQL pieces.
-
FreeDialupService(login) will return either "DISABLED", "YES", or "NO".
So, you can tell whether or not someone would be eligible for the free dialup. (I figure we can do the same thing that we do with accounts, and only give them a yellow highlighted link if they are already eligible).
This one is a function, so it is called a little differently than our other PL/SQL CARS procedures.
e.g.
$stmt = "SELECT CARS_DBA.CARS_UTILS.FreeDialupService(\'$login\') FREE FROM DUAL";
$sth = $dbh->prepare($stmt) || die "Cannot Prepare Statement";
$sth->execute();
-
The other piece is a procedure that actually creates the account:
AddFreeDialup ( session_id, login, clear_pwd, out_message);
Here's a sample call for it:
$sth = $dbh->prepare( "
BEGIN
CARS_DBA.CARS_UTILS.AddFreeDialup(:1, :2, :3, :4 );
END;" );
$sth->bind_param(1, $sessionid);
$sth->bind_param(2, $login);
$sth->bind_param(3, $pwd);
$sth->bind_param_inout(4,\$message,200);
$sth->execute();
--Breeze
|