Problem setting up OFS

[craigstats]

Hi, I recently installed the 7.0 demo. I am interested in setting up the OFS but have been unable to do so.

I added a location, created the OFS and OFS_USER accounts, and granted privileges as explained in 17.1.

But when I click Install OFS Objects, I get the following error in the Install Console:

ORA-06550: line 3, column 3:
PLS-00905: object .OFS is invalid
ORA-06550: line 3, column 3:
PL/SQL: Statement ignored

..where is the schema I want to install to. What could be the problem here? Does my schema not have all the privileges it needs? I'm not a DBA, but I believe this is an administrator-level schema in our DB.

Anything else I might be doing wrong? Anyone else have a similar issue? Thanks.

 

[Marco Kalter]

Can you let me know the compilation errors of the OFS package?

 

[craigstats]

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following...

if I add an end; line to the OFS package source, it compiles, but then when I go back and click on Install Database Objects, it overwrites my change.

I appreciate your help...if we can make use of the OFS we will certainly upgrade to 7.0.

 

[Marco Kalter]

Can you check the OFS.pck file in the OFS\SQL subdirectory in the PL/SQL Developer installation directory?

 

[craigstats]

In line 105 of ofs.pck there is a / symbol. When I paste this in a program window and compile, the compiler is throwing an error on that. Simply taking this out does not work. Thank you.

 

[craigstats]

can anyone think of why the OFS package is not compiling for me? I feel silly not being able to get this to work. Thanks.

 

[Marco Kalter]

In line 105 of ofs.pck there is a / symbol. When I paste this in a program window...

You need to open OFS.pck in a Program Window. You cannot paste it.

 

[craigstats]

OK, thanks. When I try to compile OFS.pck, I get the message Package or Function OFS_PRIVATE is in an invalid state at line 239.

 

[Marco Kalter]

Okay, can you open ofs_private.pck from the same directory and compile that?

 

[craigstats]

ofs_private.pck compiles fine on its own. It's only after I click the Install Database Objects that it says ofs_private is in an invalid state.

I appreciate your continued help on this and hope we can eventually get this worked out. Thanks.

 

[Marco Kalter]

Okay, but why is it invalid? Are there any errors when using the "Compile Invalid Objects" tool?

 

[craigstats]

I get the end-of-file errors I referenced in post 3 of this thread.

If I open the ofs.sql and ofs_private.sql individually through a program window and compile, I get no errors. However, then when I try and save an object to the OFS, I get

ORA-20000: OFS-7: Path not found. path=
ORA-06512: at ".OFS", line 8
ORA-06512: at ".OFS", line 20
ORA-06512: at ".OFS", line 108
ORA-06512: at ".OFS", line 165
ORA-06512: at ".OFS", line 8
ORA-06512: at line 2

 

[Marco Kalter]

Can you let me know how to reproduce this?

 

[Shaper]

It is easy to reproduce that.

I have done the following and got the same error (ORA-20000: OFS-7: Path not found...):

1. create user OFS identified by OFS;
grant connect, resource, query rewrite to OFS;
create user OFS_USER identified by OFS_USER;
grant dba, connect to OFS_USER;

2. Next "Tools\Preferences\Directories\Files" OFS manager:
2.1 Add Location
2.2 Filled the following data:
Name: Location
Database:
Schema: OFS
UserName: OFS_USER
3. Next pushed "Install OFS objects".

4. Clicked save location direcory and saved new location file.

5. And finally typed in "Tools\Preferences\Directories\Files" OFS Location field path to the location directory file.

After that I connected to the database as OFS_USER and tried to call "OFS open" through the Toolbar button and have got the followin error:

ORA-20000: OFS-7: Path not found...

Could you scritinize the problem?

Your early reply will be very much appreciated.

 

[Marco Kalter]

Which PL/SQL Developer version are you using?

 

[Shaper]

We use the following Developer:

PL/SQL Developer - Version 7.0.1.1066 (MBCS)Enterprise edition on Windows XP version 6.0 (build 2600) Service Pack 2.

 

[Marco Kalter]

Can you upgrade to 7.0.2 and try again?

 

[Shaper]

Now we have no spare time to download/install 7.0.2 version and check this issue.

Have you fixed this problem in 7.0.2?

Could you specify the link to 7.0.2 change/fix list?

Thanks.

 

[Shaper]

We found out that PL/SQL Developer 7.0.2 also has this bug and it looks as follows:

- ORA-20000: OFS-7 Path not found. path=New
- ORA-06512: in "OFS.OFS", line 8
- ORA-06512: in "OFS.OFS", line 20
- ORA-06512: in "OFS.OFS", line 108
- ORA-06512: in "OFS.OFS", line 165
- ORA-06512: in line 8

The error means that some path "New" is required, but it is not found.

Could you scritinize the problem?

Your early reply will be very much appreciated.

 

[Shaper]

Will this bug be fixed in the next version of PL/SQL Developer?

Thanks.

 

[Marco Kalter]

We'll investigate this and will try to fix it.