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.
> 
> 
> 

Reply via email to