strange problems with Ora9idb and apache.

From: martin kleinman <not_at_not.nl>
Date: Thu, 1 Nov 2001 09:33:45 +0100
Message-ID: <9rr1cv$kvf$1@news1.xs4all.nl>

I've just installed a fresh database (9.0.1.1) on WIndows 2000 Proffessional (sp2).

I've created 2 dads for my 2 development users which went fine. plsql mod is operational also.

I did an export of my old database (8.1.7) and imported this one on the 9.0.1.1 machine. The first thing I noticed was that in ALL my packages the following statements where changed.

SELECT COUNT(*) ..... on 8.1.7 became

SELECT COUNT .... on 9.0.1.1 thus giving all sorts of compilation errors.

another problem I'm having is with the following 2 procedures (for test purposes)

create or replace procedure test1 is
begin

htp.formopen('/pls/flitsond/test2','post');
htp.formhidden('p_id','10');
htp.formsubmit( 'p_submit','submit');
htp.formclose;

end test1;
create or replace procedure test2(p_id in number, p_submit in varchar2) as begin

htp.htmlopen;
htp.p('Pl/sql toolkit is working, id = '|| p_id);
htp.htmlclose;

end test2;

procedure 1 creates a simple form with only a submit button, when the button is pressed the test2 procedure must be executed.

htp.formopen('test2','post'); --> doesnt work
htp.formopen('test2','get'); --> works fine
htp.formopen('/flitsond/test2','post'); --> doesnt work
htp.formopen('/flitsond/test2','get'); --> works fine
htp.formopen('/pls/flitsond/test2','post'); --> doesnt work
htp.formopen('/pls/flitsond/test2','get'); --> works fine

seems everything with the post method fails.

Anyone here has had the same problems and knows what has gone wrong?

regards
Martin Received on Thu Nov 01 2001 - 02:33:45 CST