Re: Connecting to Oracle DB

Perl, DBI, and DBD::Oracle should be all you need to do the job. Maybe I misunderstood, but if you've already done it once with a MySQL DB, you'll have no problems with this. Most of the code will be the same. That's what DBI tries to accomplish ... sort of a universal DB API for perl. Just add your DBD::Oracle and change your connect string and you're off to the races.

Comment on Re: Connecting to Oracle DB

Replies are listed 'Best First'.
Re: Re: Connecting to Oracle DB by mrmorales (Initiate) on Dec 20, 2001 at 10:33 UTC
First of all thank for you input. I would like to clarify on my last post. No, I have not as of yet done anything with any of the modules. I have only read about being able to do what I'm trying to accomplish with Oracle on MySql. So now that I have everything installed, all I have to do is start with the code writing. In fact Ive started and now im getting an error regarding "DBI" and "DBD::Oracle". Everything installed just fine, but the error reads: DBI->connect(T:melchior:dev01) failed: ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) at ./insert-LDB_EXTID.pl line 11 Could not connect: ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) Now this is obviously an issue with the connect string. I'm fairly familar with Oracle and the Listener, and I can connect to the DB with Sql*Plus just fine. OH!~p.s. The Oracle server instance and client software are both on the same machine that I am trying to run the code on; so everything is local. Let me know what you think. I'm currently going through the docs on DBD::Oracle but haven't found anything specific to this yet. Thanks again.	[reply]

Replies are listed 'Best First'.

Re: Re: Connecting to Oracle DB
by mrmorales (Initiate) on Dec 20, 2001 at 10:33 UTC

First of all thank for you input. I would like to clarify on my last post. No, I have not as of yet done anything with any of the modules. I have only read about being able to do what I'm trying to accomplish with Oracle on MySql. So now that I have everything installed, all I have to do is start with the code writing. In fact Ive started and now im getting an error regarding "DBI" and "DBD::Oracle". Everything installed just fine, but the error reads: DBI->connect(T:melchior:dev01) failed: ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) at ./insert-LDB_EXTID.pl line 11 Could not connect: ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) Now this is obviously an issue with the connect string. I'm fairly familar with Oracle and the Listener, and I can connect to the DB with Sql*Plus just fine. OH!~p.s. The Oracle server instance and client software are both on the same machine that I am trying to run the code on; so everything is local. Let me know what you think. I'm currently going through the docs on DBD::Oracle but haven't found anything specific to this yet. Thanks again.

[reply]