Hello,
I having this problem of long or hanging situation
when try to do DBI->connect(...) with the Oracle
database server (the server is 7.x). From the
README.help file, I notice the following:
---
Connection/Login slow
Hi,
Oracle is new to me. But from the otn.oracle.com, the
explaination given for your error code:
---
ORA-00928 missing SELECT keyword
Cause: A SELECT subquery must be included in a
CREATE VIEW statement.
Action: Correct the syntax. Insert the required
SELECT clause aft
request of
upgrade the bloody perl!
Now need to test with the PL/SQL written from the
other guy...
--- Sei Heng Ang <[EMAIL PROTECTED]> wrote:
> I never thought this is possible...
>
> I decided (in the end), I need to upgrade the DBI +
> DBD::Oracle. And since I am
ove. Is
working in the Oracle SQL command console. So, not
sure what went wrong.
NOTE: This is interesting, the idea I can by pass
administratior and install the entire Perl into my own
directory set whatever control that /I/ want is
*fun*...
Still trying to figure out what is going on...
--- Sei H
erl +
DBI + DBD::Oracle. Unless I can prove that an upgrade
will solved all the problem.
Anyone can suggest anything?
Regard,
Sei Heng
--- Sei Heng Ang <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a function in the Oracle database, already
> created, which take in no input
Hello,
I have a function in the Oracle database, already
created, which take in no input value, out put a
status that is varchar2(6).
However, when I try to execute the following SQL in
DBD::Oracle, there was error appear.
The SQL code:
==
BEGIN
:t := test_func;
END;
=
Hi,
I know this may sound like a stupid question. Anyone
can give some hint regard Oracle PL/SQL + Perl
programming?
Any requirement that I need in order to successfully
use Perl to execute PL/SQL in Oracle?
Any site/REAME/doc that can share some insight into
this will be greatly appreciated.
Hello,
I am using PostgreSQL in one of my Server.
But, now I need to communicate it with a Oracle
database via SQLNet (I think this is what I was
told of).
I have _very_ little (close to no) experience with
Oracle. So, how do I install Oracle's DBD* in my
Linux box, thus able to do some dat
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";
my $tbh = $dbh->prepare($sqlcmd);
$tbh