Peter,
Thanks for the response, i am a beginner level of DBA. I am looking
for an help with beginer level of knoweldge. Can you please some group ids
where i can get this ?
regards,
Raveendu
On Wed, Apr 13, 2011 at 5:01 PM, Peter McLarty <
peter.mcla...@pacificdbms.com.au> wrote:
> It woul
It would depend on your level of expertise and if you are just wanting someone
to do your work for you and not read manuals or if you need help with complex
problems.
ITToolbox has various lists for starting out and if you google you will find
various advanced ones
Cheers
Peter
On 13/04/201
why not google?
I did and found this:
http://oss.oracle.com/mailman/listinfo/
On Wed, Apr 13, 2011 at 5:03 PM, Raveen du wrote:
> Dear friends,
>
> awaiting for your reply . can you please someone advis me on this please
>
> On Tue, Apr 12, 2011 at 4:12 PM, Raveen du
> wrote:
>
>> Dear Friend
Dear friends,
awaiting for your reply . can you please someone advis me on this please
On Tue, Apr 12, 2011 at 4:12 PM, Raveen du wrote:
> Dear Friends,
> As like we are having the perl user community, i am
> also looking for some email groups for Oracle DBA's. If anybody
inal Message-
From: marcos rebelo [mailto:ole...@gmail.com]
Sent: Wednesday, April 06, 2011 6:12 AM
To: Paul Johnson
Cc: beginners@perl.org
Subject: Re: Oracle nightmare
The error continues:
DBD::Oracle::db do failed: ORA-00942: table or view does not exist
(DBD ERROR: error possibly near <
The error continues:
DBD::Oracle::db do failed: ORA-00942: table or view does not exist
(DBD ERROR: error possibly near <*> indicator at char 11 in 'DROP
TABLE <*>my_table') [for Statement "DROP TABLE my_table"] at script.pl
line 31.
( n�o, não )
nok
DBD::Oracle::st execute failed: ORA-00932: inco
On Wed, Apr 06, 2011 at 10:24:37AM +0200, marcos rebelo wrote:
> Hi all
>
> I have already lost one day around coding and documentation with this
> problem, so I'm asking for help with DBD::Oracle.
>
> I'm working around the unicode and BLOB problem. Can someone help me
> setting the fooling code
> "TE" == Tony Esposito writes:
TE> Has anyone successfully used, in Oracle, a 'SELECT ... FOR UPDATE'
TE> using the Perl DBI:: ODBC?
i can't answer that, but that is far from a question for the perl
beginner's list. please post this in one of the many other places where
you will likely
Hi,
Simple,
Put:
RaiseError=> 0
Printerror=> 1
José Pedro Silva Pinto
-Original Message-
From: Lorenzo Caggioni [mailto:[EMAIL PROTECTED]
Sent: quarta-feira, 7 de Dezembro de 2005 10:50
To: beginners@perl.org
Subject: DBI:ORACLE
HI!!!
i'm tring to use DBI module
Here is the code
#!/g
> [EMAIL PROTECTED] wrote:
> > Hi all. I am attempting to install DBD::Oracle from the perl CPAN
> > shell. The installation script seems to assume that oracle is
> > installed locally. It asks me to set ORACLE_HOME to the path the
> > oracle is installed and to try again. Well I don't have oracle
[EMAIL PROTECTED] wrote:
> Hi all. I am attempting to install DBD::Oracle from the perl CPAN
> shell. The installation script seems to assume that oracle is
> installed locally. It asks me to set ORACLE_HOME to the path the
> oracle is installed and to try again. Well I don't have oracle
> installe
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 4:39 PM
To: [EMAIL PROTECTED]; beginners@perl.org
Subject: RE: :Oracle problems
Ok that makes more sense, I will look online for a reference of oracle SQL
language, that is NOT sql*plus.
Do you know where I might start
oracle.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 4:39 PM
To: [EMAIL PROTECTED]; beginners@perl.org
Subject: RE: :Oracle problems
Ok that makes more sense, I will look online for a reference of oracle SQL
language, that is NOT
:55 PM
To: Christopher L. Hood; beginners@perl.org
Subject: RE: :Oracle problems
[EMAIL PROTECTED] wrote:
> All,
>
> I am getting the following error while trying to use DBD::Oracle:
>
> DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
> ERROR: OCIStmtExecu
[EMAIL PROTECTED] wrote:
> All,
>
> I am getting the following error while trying to use DBD::Oracle:
>
> DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
> ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at
> ./oracleTest.pl line 69.
DESCRIBE is a SQL*Plus comma
Subject: RE: :Oracle problems
Subject: DBD::Oracle problems
All,
I am getting the following error while trying to use DBD::Oracle:
DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at
./oracleTest.
Subject: DBD::Oracle problems
All,
I am getting the following error while trying to use DBD::Oracle:
DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD
ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at
./oracleTest.pl line 69.
I have tested the connectio
[EMAIL PROTECTED] wrote:
> Ok here is the deal, our admin is trying to install DBD::Oracle for
> me to access one of our affiliates databases. The oracle "instant
> basic client" and "sqlplus" has been installed as well as
> GetOpt::Long.
>
> The installations all went well except for DBD::Oracle
No panic anymore. I was given a wrong database schema. Everything works
fine now.
Ant.
Dan Anderson wrote:
I'm struggling with the DBI too, one of the things that my book says is
that you can create config files the DBI will use. Is it possible that
you have an Oracle config file (perhaps stor
On Tuesday, Nov 11, 2003, at 14:50 US/Pacific, Dan Anderson wrote:
[..]
I'm struggling with the DBI too, one of the things that my book says is
that you can create config files the DBI will use. Is it possible that
you have an Oracle config file (perhaps stored by your sysadmin) that
is
giving th
I'm struggling with the DBI too, one of the things that my book says is
that you can create config files the DBI will use. Is it possible that
you have an Oracle config file (perhaps stored by your sysadmin) that is
giving the DBI the wrong ideas?
-Dan
On Tue, 2003-11-11 at 05:14, Anton Arhipov
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Anton Arhipov) writes:
>Hi!
>
>I'm a starter with this subject.
>
>my script is:
>use strict;
>use DBI;
>
>my $dbh = DBI->connect( 'dbi:Oracle:orcl', 'blah', 'blah',)|| die
>"Database connection not made: $DBI::errst
>r";
>$dbh->disconnect();
>
>
Olivier Wirz wrote:
> Hello,
>
> I try to install DBI and DBD::Oracle on a Windows XP.
>
> With DBI it works fine this way:
>
> ppm
> install DBI
>
> but it doesn't work with DBD::Oracle
>
> install DBD::Oracle
> --> Searching for 'DBD::Oracle' returned no results
>
> Is there a way to instal
hi everyone! im having a problem, i want to display 10 records at a time
per page in a cgi page, im using oracle 8 i have try'd a few things
without any luck, HELP! i could get all my records fine but i cant get
the paging to work.
david
-Original Message-
From: Hamish Whittal [mailto:[EM
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>
> We are having a problem. Any help would be appreciated.
>
> 1: We are running Perl on NT.
> 2: Perl is reading lines of code from a file, concatonating it in a
variable,
>and writing to an Oracle database.
> 3: I keep on getting a
From: [EMAIL PROTECTED]
> We are having a problem. Any help would be appreciated.
>
> 1: We are running Perl on NT.
> 2: Perl is reading lines of code from a file, concatonating it in a
> variable,
>and writing to an Oracle database.
> 3: I keep on getting a message:
>DBD::ODBC::st excut
> We are having a problem. Any help would be appreciated.
>
> 1: We are running Perl on NT.
> 2: Perl is reading lines of code from a file, concatonating
> it in a variable,
>and writing to an Oracle database.
> 3: I keep on getting a message:
>DBD::ODBC::st excute failed: [Microsoft][O
rows does not work correctly for selects.[1] This is because oracle
itself does not know how many rows are returned on the select until
they have all been fetched.
rows works correctly on inserts and updates though.
[1] rows will return non-zero after the first row is fetched,, but this
number
That seems correct to me. You may have better luck on [EMAIL PROTECTED]
if maybe this is an Oracle specific thing or such.
http://danconia.org
-Original Message-
From: Kevin Old [mailto:kold@;carolina.rr.com]
Sent: Thursday, November 14, 2002 3:10 PM
To: [EMAIL PROTECTED]
Subject: DBD::O
I haven't used much DBI but I suspect that your $rv2 is just a reference to
an array of rows so you might try doing something like "$rv2 =
scalar($sth2->rows)" to put the number of items in that array into $rv2...
BTW, why such cryptic variable names? ;-)
Of course, I may be completely off so hope
On Thu, Jun 06, 2002 at 08:34:24AM -0400, Naser Ali wrote:
> Hello everyone,
>
> I am planning to write perl programs to access Oracle database. What do I
> need to install and configure in Solaris 2.6 environment with Oracle 8i.?
> Where can I find some basic tutorials for beginners like my self
> -Original Message-
> From: Naser Ali [mailto:[EMAIL PROTECTED]]
>
>
> Hello everyone,
>
> I am planning to write perl programs to access Oracle
> database. What do I
> need to install and configure in Solaris 2.6 environment with
> Oracle 8i.?
> Where can I find some basic tutoria
>-Original Message-
>From: Danny Grzenda [mailto:[EMAIL PROTECTED]]
>
>
>I want to access our oracle db using perl dbi. Does anybody
>know what oracle
>software I need installed on my Windows workstation?
>
>I am getting the following messge error message.
>
>The dynamic link library OC
You could setup another environment script to wrap your perl in (although setting up
your environment with %ENV should work too). We do similar things by creating little
shell scripts that setup the environment, then execute our perl stuff. We have one
global env. that we source before all of our
> I'm attempting to load an oracle database and am struggling
> with how to retrieve a sequence for a table.
>
> in SQL, the value is net_seq.nextval
> how do i use this in a perl script??
Do you have DBI installed? What have you tried? Can we see some code?
AFAIK, you can't directly retrieve
my $sql = "SELECT net_seq.nextval FROM dual";
HTH
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 9:25 AM
To: [EMAIL PROTECTED]
Subject: Oracle sequences
Hi all
I'm attempting to load an oracle database and am struggling with how to
> -Original Message-
> From: Carlin Anderson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: Oracle function- Error when attempting call. Please Help !
>
> ...
> $sth = $dbh->prepare("BEGIN :result = getpickableqty(:id) END;");
Hee
- Original Message -
From: Ang Sei Heng <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 7:18 PM
Subject: Oracle Database...
> Hello Everyone,
>
> Recently I did some database connection to Oracle via DBD::Oracle.
>
> I manage to conncec to server, the follow stat
On Tue, 15 May 2001, Ang Sei Heng wrote:
> Hello Everyone,
>
> Recently I did some database connection to Oracle via DBD::Oracle.
>
> I manage to conncec to server, the follow statement does not
> work:
>
> -- ## Begin Perl Code ## --
>
> my $sqlcmd = "select * from street";
>
>
The problem seems to be that the Oracle Driver does not implement the
rows function.
Quote from 'perldoc DBI':
""rows""
$rv = $sth->rows;
Returns the number of rows affected by the last row
affecting command, or -1 if the number of rows is not
known or
40 matches
Mail list logo
