Browser Extender in Oracle10g

[LMW]

Hello,

it's a great plugin using browser extender to extend functionality for own needs.

In 10g there is a problem resolving the "#"-Variables for caption and actions.

Regards
LMW

######
using plsql/dev 6.0.5.931
and browser extender 2.0

 

[Joachim Rupik]

What do you mean? Could you please elaborate it and/or give some examples?

Joachim Rupik

 

[LMW]

For example I use a command for tables,views to show the number rows:

The caption shows (on right click on table/view):
"Table,View contains #field_0 row(s)",

so #field_0 is not resolved.
Moreover the command is not enabled (grayed).

The same situation I have with other BE-Commands.

In an Oracle 9i database everything is working.

----------------------
PL/SQL Developer Browser Extender Command

[MAIN]
NAME=Count Rows
CAPTION=Table/View contains #field_0 row(s)
OTYPE=Table,View
OOWNER=%
ONAME=%
SEPARATOR_ABOVE=Y
SEPARATOR_BELOW=N
LOAD_AND_EXECUTE=N
LOAD_COMMAND=N
LOAD_AFTER=REPLACE
LOAD_WIN_TYPE=1
PRIVILEGE_REQ=N
PRIVILEGE=
ORACLE_VERSION_REQ=N
ORACLE_VERSION=7.0.0
ONCLICK_CONFIRM=N
ONCLICK_CONFIRM_MSG=
ONCLICK_SPLASH=N
ONCLICK_SPLASH_MSG=
ONCLICK_SPLASH_MSG_BL=N
ONCLICK_SPLASH_MSG_AFTER=
ONCLICK_SPLASH_DELAY=0
ONCLICK_IGNORE_EXCEPTIONS=Y
ONPOPUP_IGNORE_EXCEPTIONS=N

[ONCLICK]

[ONPOPUP]
select count(*) from #oowner.#oname

----------------------

Regards
LMW

 

[LMW]

Hello,

it looks like BE Version 2.0 doesn't work in Oracle 10g at all.

Maybe it is disabled for this version.
Must I use BE Version 2.5 now?

Regards
LMW

 

[Joachim Rupik]

Hello,

No Browser Extender version 2.0 is not disabled (especially intentionally) for any Oracle version, it was compiled in 2002 (version 2.0.0.329).
I will check it.

Greetings,
Joachim Rupik

 

[LMW]

Hello,

I checked and I see BE is working on Windows XP SP2 for all Oracle Versions,
but not working on WIN2000 SP4 for Oracle10g

Maybe it'll help you.

Regards
LMW

 

[Joachim Rupik]

Hello,

I have checked it. It looks that Browser Extender 2.0 does not work with Oracle10 on Win2000. I have no idea why. It is a drawback (maybe Browser Extender bug), however I am glad that it works with Oracle10 anyway. The workaround for this problem has been found - simply use it on Windows XP.
If you are not able (or do not want) to follow the advise given above, try Browser Extender 2.5 - new version that will be further developed and supported. While BE 2.5 is now the only supported version of the plug-in v 2.0 will be available as free-ware.

Greetings,
Joachim Rupik