From: Peter Scott [mailto:[EMAIL PROTECTED]
Sent: 22 June 2007 13:25
To: [EMAIL PROTECTED]; dbi-users@perl.org
Subject: Re: perl pad.c Assertion !((sv)-sv_flags 0x0001) failed
On Thu, 21 Jun 2007 22:33:03 +0100, Tim Bunce wrote:
On Thu, Jun 21, 2007 at 06:47:11PM +0200, Rafael
On 8/24/06, Lampang, Arman Elianto [EMAIL PROTECTED] wrote:
*** Error code 2
make: Fatal error: Command failed for target `Oracle.o'
I use perl 5.6.1 bundled with Solaris 10 and I got this error message
Do anyone can help me ?
Use a current version of Perl.
I don't know if that is the
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: 06 October 2005 11:30
To: List - DBI users
Subject: Oracle and dbh - last_insert_id
Hi Folks
I can't get last_insert_id() to work with Oracle.
OS: GNU/Linux
DBI: V 1.48
Oracle: 9.2.0
Demo (to save you typing):
Are you sure the query only takes a few seconds and not that it only
takes a few seconds to return the rows that makes your selection
criteria. Not sure how big your database is but for anything other than
trivial data volumes I would say that performance will be very poor.
(obviously that is just
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: 20 August 2004 17:40
To: Derrick Spell
Cc: [EMAIL PROTECTED]
Subject: Re: Error starting JDBC listening server
On Thu, Aug 19, 2004 at 02:34:34PM -0400, Derrick Spell wrote:
I am trying to get DBD::JDBC running on
It can be made to work I used this to get it working
http://www.mail-archive.com/[EMAIL PROTECTED]/msg20816.html
It's a bit of a pain to do, but will work if you can't get the oracle
installer to work to give you a full install.
Ken.
-Original Message-
From: Jim Spath [mailto:[EMAIL
Did I miss something? Can't you just
Prepare-(insert into table values (sq.nextval,:1,:2,:3));
Execute(col1,col2,col3);
No SP or trigger to fire and no extra network round trips?
Ken.
--
IT Infrastructure Manager
beCogent Ltd
T: +44 1236 628140
M: +44 7770 573749
E: [EMAIL PROTECTED]
If you need the value you inserted can you not get it with the RETURNING
clause? (To be fair I've never tried this with DBI before so I don't
know if it is supported)
Ken.
--
IT Infrastructure Manager
beCogent Ltd
T: +44 1236 628140
M: +44 7770 573749
E: [EMAIL PROTECTED]
-Original
Also, don't know if it just a typo but the serial column is actually called
serial#
Ken.
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]
Sent: 14 March 2003 16:12
To: Markham, Richard; [EMAIL PROTECTED]
Subject: RE: concatenating column aliasing
Session is a
Sounds like the cgi-bin directory is in the document_root hierarchy it
doesn't match the ScriptAlias and get executed so it is just returned as a
text file. Make sure the cgi-bin is in a different directory path not in
document root then you'll just get a Document not found error.
NOTE: Pure
Not sure about setting terminal but if all you want to do is identify what
is going on from v$session or something then check out DBMS_APPLICATION_INFO
package. You can set various things that allow you to track how your code is
proceeding etc
HTH
Ken.
-Original Message-
From: [EMAIL
You can only do this the function has no side effects, or the PRAGMA
RESTRICT REFERENCES clause is used.
I forget exactly what is required but as far as I remember its quite
restrictive.
Ken.
-Original Message-
From: Steve Haslam [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2003 10:51
Can't say I would worry about this too much. Best to check the code of the
test just to make sure.
Without checking the code of the test, my initial assesment would be that
the install will work fine but you might have to be a bit carefull when
doing string comparisons with varchar2 and string
-Original Message-
From: Udo Grabowski [mailto:[EMAIL PROTECTED]]
Sent: 31 January 2003 13:51
To: [EMAIL PROTECTED]
Subject: DBD:Oracle : TNS:listener could not resolve SERVICE_NAME
Hello !
A rather difficult setup:
A 64 bit Oracle 9i Solaris 8 installation, runs with Sun
What DB are you using. Just as a matter of interest what happens if you make
it
SELECT page,count(*) FROM $Table GROUP BY page
Also I don't know if this is really the statement you want to execute but
the same effect can be acheived
with
SELECT DISTINCT page FROM $Table
Ken.
-Original
I would just ignore it myself. The compliation worked OK so anything else is
probably a test harness problem. Go with it, you'll soon know if it works
for what you need.
Ken.
-Original Message-
From: Mark Buckle [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 11:32
To: [EMAIL
Generally a function returns a value which you must assign to something. So
you could do
my $sql = qq[select OWNER.MY_FUNCTION(?,$action,?,$meta_type) from dual];
instead of trying to execute an anonymous PLSQL block, which is probably
more efficient anyway.
If you need to do it in PLSQL because
This usually happens because cron runs with no environment. Make sure you
source your .profile or set all required environment variables in your
script. Things like PATH,LD_LIBRARY_PATH etc
Ken.
-Original Message-
From: [EMAIL PROTECTED] [mailto:julien.Pringuay;nxbp.fr]
Sent: 14
Haven't had to deal with this myself but here is my thoughts
Build DBD against 9i
Make sure your 8i SID/DB Name is available in the tnsnames file of the 9i
oracle home.
The 9i client should be able to connect to the 8i database.
So alsong as you leave the oracle home set to the 9i home everything
Can't comment on limitations of DB2 or DBD::DB2 but lets face it you could
do the lcase bit on the bind parameter before the execute using perl string
functions. Then the problem goes away.
Ken.
-Original Message-
From: Belinda M. Giardine [mailto:[EMAIL PROTECTED]]
Sent: 09 October
No reason why an 8 client can't connect to a 9 database unless you dba has
specifically not installed any backward compatibility. Best test is to try
it :) I would have thought you would get more luck with 8.1 rather then 8.0
though.
Good luck
Ken.
-Original Message-
From: Matthew
What character set is the database in?
select value from v$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET'
what have you set your NLS_LANG environment variable to before your script
runs?
Are you sure the data you are getting back is wrong and not your terminal
emulator displaying it
Unless you use an ODBC bridge solution like openlink software has.
Install the openlink server on the ingress box and openlink client on the
other machine.
Not free though!
http://www.openlinksw.com
Ken.
-Original Message-
From: David Blakey [mailto:[EMAIL PROTECTED]]
Sent: 05
That is the point of varchar2 fields. If you want to maintain trailing
spaces etc it should be defined as char(20). You will have to watch out if
you use it in conditions and joins etc as in general the trailing stuff is
now important, is this what you really want?
Ken.
-Original
Things to check though not neccessarily in this order...
1. Check out DBI trace output to see if there is anything interesting there.
2. Is it data related? What if you delete the first 3000 lines and try the
remaining 6968 does it still fail after 2479?
3. Is there some bizzare DB thing going
In term of elapsed time for the load it probably won't make much difference
but if you create the indexes after the load the chaces are you will get a
better balanced index structure which should improve query time for the
future.
Ken.
-Original Message-
From: Mark Riehl [mailto:[EMAIL
Is this after you have done the execute and all the fetches? he value is not
valid until you have porcessed all the rows returned (OK in this case none
but you at least have to have tried)
Even then I'm not sure if all DBD's support it? Why not just to the standard
while-fetchrow loop and count
I have just tried to use DBD::CSV and seem to be missing something
fundamental
I have written a simple select * from table query which seems to return no
data.
The associated file seems to being read as the NUM_OF_FIELDS in the trace is
getting set to 16. I have attached the trace (level 1) if
-
From: Gaul, Ken [mailto:[EMAIL PROTECTED]]
Sent: 07 May 2002 12:52
To: '[EMAIL PROTECTED]'
Subject: DBD:CSV
I have just tried to use DBD::CSV and seem to be missing something
fundamental
I have written a simple select * from table query which seems to return no
data.
The associated file seems
OK I think this is to do with the default type that the column is being
bound to. I assume that name is a varchar column.
By default varchar's remove trailing spaces so insead of the implicit bind
what if you do...?
$sth-bind_param(1,'Mario ', {TYPE = SQL_CHAR});
$sth-execute;
This should
Has anybody ever encountered the ORA-00928 error while executing a
pre-prepared insert statement?
The parse succeeds OK, the bindings seem to happen OK, but during the
dbd_st_Execute INSERT (out0,lob0) phase of execution the error is
thrown. The DB error is just (DBD ERROR: OCIStmtExecute) on
31 matches
Mail list logo