Print Thread
Error Report: PL/SQL Doc
#51887 07/27/15 11:05 PM
Joined: Jul 2003
Posts: 1,140
Virginia, USA
Member
OP Offline
Member
Joined: Jul 2003
Posts: 1,140
Virginia, USA
The documentation says that from a Command window we can use the command

plugin plsqldoc generate

to create a batch script to create/refersh our documentation.

this only seems to work if the object is a package. on a table I got the following (I took out my schema name):


SQL> plugin plsqldoc generate dept
Generating TABLE <schema name>.DEPT
Failed!



Scott Mattes
Re: Error Report: PL/SQL Doc
ScottMattes #51888 07/27/15 11:19 PM
Joined: Jul 2003
Posts: 1,140
Virginia, USA
Member
OP Offline
Member
Joined: Jul 2003
Posts: 1,140
Virginia, USA
I have an update.

if I right click in the Obj Navigator and select Generate I am told:

plsqldev
could not generate documentation for DEPT

ORA-01012: not logged on
Process ID: xxxx
Session ID: xxx Serial Number: xxx
(Generate Table)

So I thought it might just be possible that I was inactive long enough so I did a Session / Logoff / All and logged back on.

I got the same error. According to the Window title I am connected, the Command Window status are agrees and I can issue DML in the Command window and it returns data.

I closed PLSD and restarted it. in Obj Nav I hi-lighted all the tables that start with 'A', right clicked, selected Generate and it is running along fine.


Scott Mattes

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.026s Queries: 14 (0.007s) Memory: 2.4996 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-15 11:19:10 UTC
Valid HTML 5 and Valid CSS