Intermedia HITTAB

From: Simon Mailhot <simon.mailhot_at_cognicase.ca>
Date: Sat, 21 Jul 2001 21:58:58 GMT
Message-ID: <a168ad68.0106260524.31c0f033_at_posting.google.com>

Hi,
I'm using a perl program to access an Oracle 8.1.6 DB. The program was running on another computer so I'm installing everything on another computer with a new DB... The problem is that I can't use CTX_QUERY... Intermedia is there but I'm receiving an error in the Apache error log...

LOG:
PLS-00302: component 'HITTAB' must be declared PLS-00302: component 'CONTAINS' must be declared

The perl code look like this:

    my $sth = $self->{DBH}->prepare(q{

        BEGIN
            ctx_query.gettab(CTX_QUERY.HITTAB, ?, 2);
        END;

});

AND
    my $sth = $self->{DBH}->prepare(q{

        BEGIN
            ctx_query.contains(?, ?, ?);
        END;

});

Usefull info...
Its a new installation so a new server, new DB ... Oracle = 8.1.6
Apache = 1.3.20 on RedHat 6.2
Perl 5.005_03

Tanks !

Simon
simon.mailhot_at_cognicase.ca Received on Sat Jul 21 2001 - 23:58:58 CEST