Invalid Filename from Compare User Objects/Show Differences

[andyh]

Hi,

I've set Beyond Compare 2 as my external comparison tool.

When I perform a Compare User Objects/Show Differences I get an Error dialog box with the message 'Invalid Filename'.

Running Windows XP.

Any ideas?

 

[Marco Kalter]

Any idea what the actual filename is?

 

[andyh]

No, what filename could it be talking about?

I'm comparing two packages.

 

[William Robertson]

> No, what filename could it be talking about?

One of the files you're asking it to compare, maybe.

 

[Marco Kalter]

The package sources are saved to a temporary file, and then passed to the compare utility. Perhaps "Beyonf Compare 2" cannot handle file/directory names with spaces or other special characters.

 

[andyh]

But... Tools/Compare User Objects compares objects in the database not in files.

 

[andyh]

Originally posted by Marco Kalter:
The package sources are saved to a temporary file, and then passed to the compare utility. Perhaps "Beyonf Compare 2" cannot handle file/directory names with spaces or other special characters.

Not sure, I'll check.

The error dialog is the same whether I declare an external program or not, which makes me think that it's being generated by PL/SQL Developer.

 

[William Robertson]

Yes, those temporary files. How else could it work?

 

[andyh]

Originally posted by William Robertson:
Yes, those temporary files. How else could it work?

You tell me the file names and I'll go and look...

 

[andyh]

Originally posted by andyh:

Originally posted by Marco Kalter:
The package sources are saved to a temporary file, and then passed to the compare utility. Perhaps "Beyonf Compare 2" cannot handle file/directory names with spaces or other special characters.

Not sure, I'll check.

The error dialog is the same whether I declare an external program or not, which makes me think that it's being generated by PL/SQL Developer.

BC2 should be OK with names and spaces. I think that the dialog box belongs to PL/SQL Developer, could you confirm? If so, I assume that PL/SQL Developer is having problems communicating with BC2?

 

[mike]

If it helps, on my PC, PL/SQL Developer generates names that start with "PLS_APPS.AT" then appends the instance name and then ".txt".

On my PC, it stores them in the temp directory: "C:\Documents and Settings\(username)\Local Settings\Temp"

Maybe you can verify that the filenames look OK and can open fine? Good luck.

Mike

 

[andyh]

Originally posted by mike:
If it helps, on my PC, PL/SQL Developer generates names that start with "PLS_APPS.AT" then appends the instance name and then ".txt".

On my PC, it stores them in the temp directory: "C:\Documents and Settings\(username)\Local Settings\Temp"

Maybe you can verify that the filenames look OK and can open fine? Good luck.

Mike

Thanks for the pointer - it identified the problem! I didn't have any of the files of the format you mentioned, but realized that I connect to my databases using URL connection strings (//machine/service_name) format rather than using tnsnames format.

I guess that this makes problems for PL/SQL Developer when it tries to to build the filename.

Is this a bug?

 

[andyh]

I guess that this makes problems for PL/SQL Developer when it tries to to build the filename.

Is this a bug?

I should have mentioned that I have re-tested using tnsnames format and that comparison works as expected.