Re: Connect to Oracle 8.1.7

From: David N Murray (dmurray_at_jsbsystems.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 14:38:06 -0500 (EST)
To: "Spiraquis Alexis (SFO)" <spiraqua@telefonica.com.ar>

What happens if you try the statement in sqlplus user/pass@dbname? This
doesn't look like a connectivity issue, except where user may not own
the table you are selecting from, i.e. try "select ... from owner.table"
if you are connecting as 'user' rather than 'owner'. Of course, 'user'
needs select permissions on table, but that's a different error IIRC.

HTH,
Dave

On Jan 24, Spiraquis Alexis (SFO) scribed:

> Hello
>
> I have on my server 5.005_03 built for sun4-solaris installed with
> DBI(v1.13). I was previously accesing a Oracle 7.3.4 Database without
> problems. Now I tried to access the same DB but migrated to 8.1.7 and I get
> the following error:
> DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist
> (DBD: error possibly near <*> indicator at char 52 in ' select m.swValue
>
> There is no "<*>" in my query and the same Perl page with Oracle 7.3.4
> works.
> What I guess is that I use two types of connections. With this type I donīt
> have any problems:
> sub adv_connect
> {
> #local ($sql, @inputdata) = @_ ;
>
> local ($dbh) = DBI->connect('dbi:Oracle:dbname','user','pass',
> );
> $dbh->{AutoCommit} = 0;
> return ($dbh);
> }
>
> But with this type of connection I get the error mentioned above:
> sub adv_connection
> {
> local ($sql, @inputdata) = @_ ;
> local ($dbh) = DBI->connect('dbi:Oracle:dbname','user','pass',
> );
> $dbh->{AutoCommit} = 0;
> local ($sth) = $dbh->prepare($sql) or return ($dbh,undef);
> $sth->execute();
> $sth->bind_columns(undef, @inputdata);
> return ($dbh, $sth);
> }
>
> The question is: Do I need to change all these types of connections and use
> the first one? Or I need to migrate the Perl or DBI version?
> Thank you very much
>
>
>

Relevant Pages

  • Re: Automatically logging in to SQL Server (w/Access Front End)
    ... Not sure if this works for 2 connections but.... ... I use this procedure to re-create links to SQL Server. ... Public Sub LinkSQLServerTables ... Set dbs = CurrentDb ...
    (microsoft.public.access.modulesdaovba)
  • using Net::SSH::Expect within a thread fails
    ... list of IP addresses from the IAD module and then create a few threads ... sub threadsub { ... my $exe_user = shift; ... will make a lot of connections once it's up and running. ...
    (perl.beginners)
  • Re: Cant buikd a Link between Unbound Forms
    ... > primary key of the main form and foreign key in the sub forms. ... > master fields to change the linking I get a message saying "Can't build a ... and don't get the field linker box to open. ... > The form/subform connections work 99% of the time, but I get a ODBC call ...
    (microsoft.public.access.forms)
  • IRowConsumer webpart runat client
    ... (with runat client because i'm using an OWC Pivottable to interface). ... many connections can ... public override ConnectionRunAt CanRunAt() ... Public Overrides Sub EnsureInterfaces() ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: 2 ways to close a connection
    ... great job in this newsgroup, ... whether to rely on GC to close the connections for you. ... > Sub Main ... > "Cor Ligthert" wrote in message ...
    (microsoft.public.dotnet.languages.vb)