Hi, there. Hope this is not off-topic :)
I have been developing for a couple of months with DBI:Oracle against
Oracle7.3 and now I need to use the features of Apache::Session::DBI. I have read the
manpage and every page I found on Apache.org and Google, but the simplest sample code
don't work.
I've been putting an eye on DBIStore.pm and it says:
To use this module, you will need these columns in a table
called 'sessions':
id char(16)
length int(11)
a_session text
Where the a_session column needs to be able to handle arbitrarily
long binary data.
There is no such table in my Oracle database, but I don't think thats the problem,
because it would say "invalid table name" instead of "no statement parsed".
I'm using perl 5.005, DBI 1.13-3, DBD:Oracle 1.08 and Oracle 7.3.2
Here's my script:
#!/usr/bin/perl -w
use strict;
use Apache::Session::DBI;
my %session;
print "Content-Type: text/html\n\n";
print "<HTML><BODY>";
print "<h3>Session example</h3>";
tie %session, 'Apache::Session::DBI', undef, {DataSource => 'dbi:Oracle:mydb' ,
UserName => 'myuser' , Password => 'mypassword'};
$session{userid} = 'USER';
my $id = $session{_session_id};
print "<H3>The session id is: $id<H3>";
print "<H3>My user is: $session{userid}</H3>";
print "</BODY></HTML>";
exit;
---------------
And here's what Apache's error.log says yo me:
[Fri Jan 18 09:34:20 2002] [error] (in cleanup) DBD::Oracle::st execute failed:
ORA-01003: no statement parsed (DBD ERROR: OCIStmtExecute) at
/usr/lib/perl5/Apache/Session/DBIStore.pm line 143.
panic: POPSTACK
Callback called exit.
----------------
Thanks in advance
--
==============================
Felipe Mart�nez Hermo
[EMAIL PROTECTED]
[EMAIL PROTECTED]
==============================
Servicios Inform�ticos
UGT Galicia
[EMAIL PROTECTED]
==============================
