chine as your DB. I'm not whether from a licensing perspective they
count logical connections, or physical connections. If it's the former,
you're still screwed.
-Original Message-
From: CHEN SEI-LIM [mailto:[EMAIL PROTECTED]]
Sent: Monday, 12 November 2001 2:34 PM
To: St
Woops, the array subscript should have been (i) instead of (l_idx), but I'm
sure you got the idea.
$anon_plsql = $dbh -> prepare (q (
DECLARE
l_idx PLS_INTEGER := 0 ;
BEGIN
FOR i IN 1 .. 10 LOOP
:arr (i) := 'Hello ' || i ;
END LOOP ;
END ;
Hi there,
Is it possible to do something like this (I know the code I have here won't
work) ...
$anon_plsql = $dbh -> prepare (q (
DECLARE
l_idx PLS_INTEGER := 0 ;
BEGIN
FOR i IN 1 .. 10 LOOP
:arr (l_idx) := 'Hello ' || i ;
END LOOP ;
END
9i is a lot more timezone aware - if thats of any use. You can have a data
type of "TIMESTAMP WITH [LOCAL] TIMEZONE", however I'm not sure of whether
the Oracle::DBD supports the new data types.
-Original Message-
From: jie zhang [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 3 October 2001
The maximum length of an index is a function of the Oracle block size.
Since Oracle 8, the maximum length of a varchar2 is 4000 (no bigger even in
9i). An index entry is limited in length to 1/3 the block size, so to get
an index on a varchar2(4000) column, you would need a 16K block size.
Steve
Try this ...
select * from v$session where audsid = userenv ('sessionid')
Steve
-Original Message-
From: Jay Strauss [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 11 September 2001 10:38 AM
To: [EMAIL PROTECTED]
Subject: This connection with DBD::Oracle
Hi,
Is there any attribute(s) of t
Tim,
If you have a look at the doco on dbms_output, you will see it really does
nothing special apart from buffering the output in an internal buffer. That
is why it is limited in the amount of output you can produce using it.
SQL*Plus, and other tools that are dbms_output 'aware' simply make a
works, if I install the client and SQL*NET, how do I tell my
program to use it ?
Currently I just say
my $dbh = DBI->connect( "dbi:Oracle:SDADATA", "username", "password"
)
-Original Message-
From: Steven Baldwin [mailto:[EMAIL PROTE
Couldn't you install the Oracle client on the linux box, and access the
Solaris box via SQL*Net - using DBD::Oracle on the Linux box exactly as you
do on the Sun box ?
-Original Message-
From: Mark A. Werner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 27 June 2001 7:39 AM
To: '[EMAIL PROT
Actually, if you are using Oracle 8 or higher, you can use the RETURNING
clause of a DML statement to give you any column. The syntax is something
like this ..
:
$insJR = $dbh -> prepare (q (
INSERT
INTOIIJobRun (IIJobID, StartTimeStamp)
VALUES (:jobid, pkg_Calc.Now)
RETURNI
My sincere apologies for posting here, but I've tried the Perl news groups
without success, and am desperate to get this working.
I have (after experiencing the usual pain), got DBI-1.14 and DBD-Oracle-1.06
working quite OK. I now want to install the MQSeries module. I've done it
on a sun machi
Don't forget you need to have an entry in the init file (utl_file_dir=...)
to include the directory you are trying to access.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 3 April 2001 2:07 PM
To: Mark Wagner; [EMAIL PROTECTED]
Subject: RE: help needed or
st, and tidy up
after itself. I'm sure you know how to do all that.
Having said all this, it will work, but for large files, it'll probably be
pretty slow.
Hope this helps,
Steve
-Original Message-
From: Mark Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, 23 March 2001 8:47 AM
T
Just thinking a bit more, if you are using 8i, you could use PL/SQL to read
the file, and insert into a table of type GLOBAL TEMPORARY, and then just
fetch from the table in a single array operation. Probably be much lighter
on the network. However, same caveats apply as to the entry in the
init
Mark,
If you use the PL/SQL utl_file package, this runs on the server, regardless
of where it is executed from, so can read the trace file. Furthermore, it
is executed as an 'oracle' owned process, so has the appropriate
permissions.
Let me know if you need any more help.
Cheers,
Steve
-
Silly question, but are you trying to run on a non-Unix system ?
-Original Message-
From: Kiran Kumar M [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 9:45 AM
To: Anna Fong
Cc: [EMAIL PROTECTED]
Subject: Re: How to get the Date + some days
Yes, I installed it.. but it is the
nks
very much to the pioneers
Steve
-Original Message-
From: Steven Baldwin
Sent: Monday, 29 January 2001 11:31 AM
To: [EMAIL PROTECTED]
Subject: make failure on hp-ux 11
We've finally got the official HP ansi C compiler installed, and when I try
to rebuild perl, I get the following.
We've finally got the official HP ansi C compiler installed, and when I try
to rebuild perl, I get the following. I'm sure it's because I answered
incorrectly to one of the questions, but I thought I answered the default to
them all, except as per Lincoln's new HP-UX 11 instructions.
Thanks for
18 matches
Mail list logo
