| Author |
Is there any Stored Procedure to remove MobiLink user from an Oracle consolidated database?
|
|
|
| 9.0.2.2451
The consolidated database is Oracle 9i. I have run syncora.sql provided in
the MobiLink installation already. Is there is any Oracle Stored Procedure
to delete the MobiLink user from the consolidated database? If not, I
believe I have to write one to delete the records from ml_subscription and
ml_user. Am I correct?
Thanks in advance!
| |
| Liam Cavanagh 2005-06-17, 9:24 am |
| I have used the following one with an ASA consolidated to delete all of the
users.
CREATE PROCEDURE ml_delete_user( IN ml_user_id varchar(12))
BEGIN
DELETE ml_subscription where user_id = (select user_id from ml_user where
name = ml_user_id );
DELETE ml_user where name = ml_user_id
END;
--
Liam Cavanagh
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Product Management
"Roy" <abc@abc.com> wrote in message news:42b287d3@forums
-2-dub...
> 9.0.2.2451
>
> The consolidated database is Oracle 9i. I have run syncora.sql provided
> in the MobiLink installation already. Is there is any Oracle Stored
> Procedure to delete the MobiLink user from the consolidated database? If
> not, I believe I have to write one to delete the records from
> ml_subscription and ml_user. Am I correct?
>
> Thanks in advance!
>
| |
| Breck Carter [TeamSybase] 2005-06-18, 7:24 am |
| Suggestion: use varchar(128) for parameter specification.
Also, be sure to COMMIT... uncommitted changes to ml_* tables have
been known to block all synchronizations when the DBA goes to lunch :)
Breck Often Does Foolish Things When Hungry
On 17 Jun 2005 06:17:22 -0700, "Liam Cavanagh"
<Liam. CavanaghNO@SPAMianyw
here.com> wrote:
>I have used the following one with an ASA consolidated to delete all of the
>users.
>
>CREATE PROCEDURE ml_delete_user( IN ml_user_id varchar(12))
>BEGIN
> DELETE ml_subscription where user_id = (select user_id from ml_user where
>name = ml_user_id );
> DELETE ml_user where name = ml_user_id
>END;
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|