mORMot Open Source

yoanq

Member

Registered: 2013-01-03

Posts: 24

Problem with Oracle SYSDBA connection

Hi, ab.

We have problems when try to connect to Oracle using SYS user. After debuging code we introduce in procedure TSQLDBOracleConnection.Connect this code and work:
    //Connect using SYSDBA mode
    if Props.UserID = 'SYS' then
      mode := OCI_SYSDBA;

before Check(self,nil,SessionBegin(fContext,fError,fSession,OCI_CRED_RDBMS,mode),fError);

What do you think about it?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Problem with Oracle SYSDBA connection

It has been included by http://synopse.info/fossil/info/6ed139d9eb

Thanks for the feedback!