Click to See Complete Forum and Search --> : setting document Path in file system document store


santo
07-20-2005, 04:03 AM
hi,

Is it possible to have the basic path defined in
ctx_ddl.set_attribute, and all the subfolders in the
basic path defined in along with the document name
in the database.

for eg:

begin
ctx_ddl.create_preference('docname','FILE_DATASTORE');
ctx_ddl.set_attribute('docname','PATH','c:\temp\');
end;
/

In the table (mydocs)
mydocid doc_name
1 loc1\test.doc
2 loc2\recs.Pdf
3 loc1\oracle9i.doc

It should now take the path as
c:\temp\loc1\test.doc


Database: ORacle 9i windows.

thanx.

cheers
sam

santo
07-20-2005, 05:20 AM
hi,

one more point to the above.

Is it possbile to just give the path as c:\temp\
and all the sub folders under it are searched.

thanx

cheers
sam