[AOLSERVER] Oracle 9i

[Barry Books]

I'm moving an ACS site to 9i and Aolserver 4.0. I've built nsoracle-2.6 and
linked with the oci9 libs and I started getting this in my logs. It appears
from the Oracle site there is a change in the drivers that requires
initilizing bind variables. I'm assuming this requires a driver change. Does
anyone have a patch?

thanks
barry

[17/Sep/2003:14:32:28][2360.6][-conn:openacs::2] Error: SQL():
ora8.c:3370:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01480:
trailing null missing from STR bind value

The code is

   set out [ns_ora exec_plsql $db  {
declare
status  number;
linevarchar2(4000);
ret varchar2(32000);
begin
status := 0;
ret := ' ';

while  status = 0  loop
dbms_output.get_line(line,status);
if ( status = 0 ) then
ret :=  ret ||  line || 'br';
end if;
end loop;

:1 := ret;
end;
} ]


--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of 
your email blank.

Re: [AOLSERVER] Oracle 9i

[Don Baccus]

On Wednesday 17 September 2003 12:45 pm, Barry Books wrote:
 I'm moving an ACS site to 9i and Aolserver 4.0. I've built nsoracle-2.6 and
 linked with the oci9 libs and I started getting this in my logs. It appears
 from the Oracle site there is a change in the drivers that requires
 initilizing bind variables. I'm assuming this requires a driver change.
 Does anyone have a patch?

Try asking on our OpenACS site - a couple of folks have been moving the
toolkit to Oracle 9i and have it working, and haven't mentioned any driver
change being necessary ...

--
Don Baccus
Portland, OR
http://donb.furfly.net, http://birdnotes.net, http://openacs.org


--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of 
your email blank.

Re: [AOLSERVER] Oracle 9i on RedHat 8.0?

[Bruno Mattarollo]

I am actually downloading Oracle 9i to try it ... I just installed RedHat 8
yesterday ...

But can't promise anything on feedback yet as the download from 9i is going
very very slow

/B
--Bruno Mattarollo [ [EMAIL PROTECTED] ]
   SysAdmin/TechLead - Greenpeace

- Original Message -
From: Jeff Davis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 6:56 PM
Subject: [AOLSERVER] Oracle 9i on RedHat 8.0?


 Has anyone installed the former on the later yet?

 I need to reinstall redhat and wondered if it was worth grabbing 8.0.