Forum OpenACS Q&A: Oracle Text Setup

Collapse
Posted by Dick Weisinger on
I have a question with Oracle 9 Text.
I get the following error during configuration:

begin
ctx_ddl.set_attribute ('PATH', '');
ctx_ddl.create_preference('FILE_STORE', 'External Files', 'OSFILE');
end;
/

ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'SET_ATTRIBUTE'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_PREFERENCE'
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored

I'm not sure what's wrong.
Any idea?  Must be some kind of configuration, but it appears that Oracle Text has
successfully installed.  Oracle Note 275689.1 has a description about verifying the Text installation and that all checks out OK.

I am running this as a user with ctxapp role.

Collapse
2: Re: Oracle Text Setup (response to 1)
Posted by Dirk Gomez on
Have a look at the docs at http://download-west.oracle.com/docs/cd/B10501_01/text.920/a96518/cddlpkg.htm#16740

The API has changed it seems.