Home » Server Options » Text & interMedia » ORACLE INTERMEDIA TEXT
ORACLE INTERMEDIA TEXT [message #76027] Mon, 10 March 2003 00:13 Go to next message
Vinu
Messages: 13
Registered: March 2003
Junior Member
Hello,

My Oracle server on which Intermedia is implemented is in the intranet within a firewall.

These are the steps I followed. The index creation does not work eventually giving this error.

DRG-11622: URL store: unknown HTTP error getting http://www.yahoo.com

What should I do next ?

SQL> CREATE TABLE DOCSVIB (
2 IDDOC NUMBER NOT NULL,
3 TEXTDOCURL VARCHAR2 (80),
4 PRIMARY KEY ( IDDOC ));

Table created.

SQL> INSERT INTO DOCSVIB ( IDDOC, TEXTDOCURL ) VALUES (111, 'http://www.yahoo.com');

1 row created.

SQL> exec ctx_ddl.create_preference('URL_PREFvib','URL_DATASTORE');

PL/SQL procedure successfully completed.

SQL> exec ctx_ddl.set_attribute('URL_PREFvib','HTTP_PROXY','208.220.241.222');

PL/SQL procedure successfully completed.

SQL> exec ctx_ddl.set_attribute('URL_PREFvib','Timeout','300');

PL/SQL procedure successfully completed.

SQL> CREATE INDEX datastores_textvib ON DOCSVIB ( TEXTDOCURL )
2 indextype IS ctxsys.context
3 parameters ( 'Datastore URL_PREFvib' );

Index created.

Regards,
Vinu
Append - Server version 8.1.7.3 [message #76028 is a reply to message #76027] Mon, 10 March 2003 02:14 Go to previous message
Vinu
Messages: 13
Registered: March 2003
Junior Member
I am using Oracle 8.1.7.3 version. If this error is due to proxy authentication, please tell me what kind of access is required for the same.
Previous Topic: Can't get the CONTAINS operator to work within PL/SQL functions
Next Topic: OLD AND NEW In INSERT TRIGGER
Goto Forum:
  


Current Time: Thu Mar 28 17:18:20 CDT 2024