Hi all,
i need you help. I write at moment a java programm for fulltext search in the oracle data base. I will specify the preference in CREATE INDEX statement. For example:
begin
ctx_ddl.create_preference('mypref', 'file_datastore');
ctx_ddl.set_attribute('mypref', 'path', '/docs');
end;

In java:
CallableStatement cstmt = conn. prepareCall("begin ctx_ddl.create_preference(?, ?); end;");
cstmt.setString(1, 'mypref');
cstmt.setString(2, 'file_datestore');
cstmt.execute();

CallableStatement cstmt = conn. prepareCall("begin ctx_ddl.set_attribute(?, ?, ?); end;");
cstmt.setString(1, 'mypref');
cstmt.setString(2, 'path');
cstmt.setString(3, '/docs');
cstmt.execute();

Who can tell me, whether this programm is correct or not. Perhaps i should write create_preference und set_attribute in the same prepareCall. But how can i indicate the parameter?

Please help me. Thank you.

Diwen