Thanks Goncharova. I'll take a look at adding this functionality.
I'll probably do it via connect so you'll be able to do
something like:
DBI->connect("dbi:Oracle:foo", $user, $pass, {
ora_old_password => $old_password,
});
If ora_old_password is supplied it'll call OCIPasswordChange(...)
report any error as a warning, then proceed to connect using $pass.
Could you try doing that yourself? It'll mean it gets implemented sooner
if you can.
Thanks.
Tim.
On Fri, Mar 05, 2004 at 11:10:00AM +0300, Goncharova Natalia wrote:
>
> Diff -u dbddimp.c old_dbdimp.c
>
> @@ -192,40 +193,7 @@
>
>
> /* ==================================================================
> */
> -/*
> -function for change password user
> -*/
> -int
> -dbd_db_change_password(dbh, imp_dbh,
> dbname,user_name,old_password,new_password)
> - SV *dbh;
> - imp_dbh_t *imp_dbh;
> - char *dbname;
> - char *user_name;
> - char *old_password;
> - char *new_password;
> -{
> - sword status;
> - #ifdef OCI_V8_SYNTAX
> - OCIServerAttach_log_stat(imp_dbh, dbname, status);
> - if (status != OCI_SUCCESS) {
> - oci_error(dbh, imp_dbh->errhp, status,
> "OCIServerAttach");
> - OCIHandleFree_log_stat(imp_dbh->srvhp, OCI_HTYPE_SERVER,
> status);
> - OCIHandleFree_log_stat(imp_dbh->svchp, OCI_HTYPE_SVCCTX,
> status);
> - OCIHandleFree_log_stat(imp_dbh->errhp, OCI_HTYPE_ERROR,
> status);
> - return 0;
> - }
> -
> OCIPasswordChange(dbh,status,(text*)user_name,(sb4)strlen(user_name),(te
> xt*)old_password,(sb4)strlen(old_password),(text*)new_password,(sb4)strl
> en(new_password),OCI_DEFAULT);
> -
> - #else
> -
> - #endif
> - if(status!=OCI_SUCCESS){
> - oci_error(dbh, imp_dbh->errhp, status, "OCIPasswordChange");
> - }
> - return 1;
> -
> -}
> -/* ================================================================= */
>
> -----Original Message-----
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 04, 2004 4:41 PM
> To: Goncharova Natalia
> Cc: [EMAIL PROTECTED]
> Subject: Re: I want to add new function in DBD, DBI
>
> On Thu, Mar 04, 2004 at 03:24:39PM +0300, Goncharova Natalia wrote:
> > Hello,
> > I need a help. I write program on perl. I use DBD:Orcale, DBI
> modules to connect to Oracle database. I
> > need to change password of database user using OCI fuctions. I have
> written the new function in
> > DBD/dbddimp.c, but I can't call this function from Oracle.pm. Could
> you help me.
>
> Please post the patch (diff -u dbdimp.c.old dbddimp.c) to
> [EMAIL PROTECTED]
> I'll discuss it with you there.
>
> Thanks!
>
> Tim.
>
>
>