Xref: alice comp.databases.oracle.server:69279
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!logbridge.uoregon.edu!WCG2!209.113.65.250!korova.insync.net!insync!not-for-mail
From: "Joet Singh" <jsingh@bigfoot.com>
Newsgroups: comp.databases.oracle.server
Subject: Pl/SQl procedure
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <QjxM3.7857$Ph7.39186@insync>
Date: Mon, 11 Oct 1999 21:48:06 -0500
X-Complaints-To: abuse@insync.net
X-Trace: insync 939696496 207.170.71.195 (Mon, 11 Oct 1999 21:48:16 CDT)
NNTP-Posting-Date: Mon, 11 Oct 1999 21:48:16 CDT
Organization: Insync Internet Services, Inc.

Anybody out there already have a procedure for changing user password?
Where the user gives there old password and new password.  I am using PL/SQL
8.0 and the main problem I am having is phrasing "alter" statement with in
the procedure.  Any help is appreciated.