#57 Bug with wildcards in -sql

[trm]

Bug with wildcards in -sql

While

-sql SYS.DBMS_OUTPUT,SYS.DBMS_PIPE

works,

-sql SYS.DBMS%

or

-sql %

do not.

[Albert Tumanov]

Logged In: YES
user_id=86901

I am afraid I did not understand the problem.
Can you please provide an example input file for pldoc that
causes a problem ?

[Nobody/Anonymous]

Logged In: NO

Take the well-working example from the user guide:

call pldoc.bat -url jdbc:oracle:thin:@localhost:1521:ORCL -
user SCOTT -password TIGER -sql
SYS.DBMS_PIPE,SYS.DBMS_OUTPUT

In the user guide, the "-sql" option is described as
follows:

"[...]An object name may be prepended by a schema name and
may have SQL wildcards.[...]"

Thus, I tried to run

call pldoc.bat -url jdbc:oracle:thin:@localhost:1521:ORCL -
user SCOTT -password TIGER -sql SYS.DBMS%

which failed as I described.

Thanks for your help.

[SourceForge Robot]

Logged In: YES
user_id=1312539

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

[trm]

Logged In: YES
user_id=1020225

Take the well-working example from the user guide:

call pldoc.bat -url jdbc:oracle:thin:@localhost:1521:ORCL -
user SCOTT -password TIGER -sql
SYS.DBMS_PIPE,SYS.DBMS_OUTPUT

In the user guide, the "-sql" option is described as
follows:

"[...]An object name may be prepended by a schema name and

may have SQL wildcards.[...]"

Thus, I tried to run

call pldoc.bat -url jdbc:oracle:thin:@localhost:1521:ORCL -
user SCOTT -password TIGER -sql SYS.DBMS%

which failed as I described.

Thanks for your help.

[Torsten Kleiber]

Logged In: YES
user_id=1836297
Originator: NO

Hi!
I have the same problem.
Scott is the example schema from oracle. SYS.UTL_% should be return some oracle builtin packages.
I use version 11g here.
I have done following requested from sys account:
grant select_catalog_role to scott
After calling batch file containing:
set ORACLE_HOME=<Oracle Home>
call pldoc.bat -url jdbc:oracle:thin:@localhost:1521:<SID> -user SCOTT -password tiger -sql SYS.UTL_% -d test
I get following output in my command window:
Object(s) like SYS.UTL_ do not exist or SCOTT does not have enough permissions (SELECT_CATALOG_ROLE role).
Both is not true.
Regards
Torsten

[Torsten Kleiber]

Logged In: YES
user_id=1836297
Originator: NO

Furthermore following does not work too:
call pldoc.bat -url jdbc:oracle:thin:@localhost:1521:e11g -user SCOTT -password e11g -sql SCOTT.% -d test
This should read local object of scott, this should definitely reachable for user SCOTT.
Get following error:
Object(s) like SCOTT.SCOTT do not exist or SCOTT does not have enough permissions (SELECT_CATALOG_ROLE role).
Seems that the wildcard is complety wrong interpreted as I never say that object SCOTT.SCOTT has to be read.

[Stuart Turton]

This is probably to do with DOS/Windows: environment variables and batch parameters use the percent character

e.g. SET PATH=c:\my-path;%PATH%

In DOS/Windows batch/command scripts a per-cent character is "%%"

To get a wild-card per-cent character through pldoc.bat and the pldoc.jar command-line unmangled, I use "SYSTEM.%%%% "