plsqldoc: Read from files

[Remo Laubacher]

I've got a problem.. We'are writing our packages outside of PL SQL Developer (we do this because we need separate files for harvest).

We have a tool to install this files (packages) but there is one big problem: This tool strips the comments. This is okay because there are a lot of comments which aren't useful...

So me question: Is it possible to generate the plsql documentation from files?

Thanks!
Remo Laubacher

 

[Marco Kalter]

This is currently not possible, but we have had some more requests for this.

I'm not sure why you write your packages outside of PL/SQL Developer though. Can you clarify this?

------------------
Marco Kalter
Allround Automations

 

[Remo Laubacher]

I know it's a bad idea to write packages outside of plsql developer, but I can not change this..

there are a few reasion why we must use files:

1. We are using harvest (a tool like cvs..) so we need files.. I know I can export a package source to a file after I wrote it, but there are more reasons..

2. We use Rational Rose to create our database models. After we created it, we have to use a tool named "Design" to create a "storage script" and the "business logic" which is in reality the package.. this tool always creates a file..

It is possible to create a package without this tool, but then I have much more work because "Design" generates a lot of methods for me..

It also generates a few things which I don't have to do by my self in centura (the language we write the gui)

I wasn't the one who definied this process.. This is because we just extend the functionality of IFS...

PS: Sorry for my bad english.. I never learnt it..

[This message has been edited by Remo Laubacher (edited 03 July 2003).]

 

[Marco Kalter]

It is the basic philosophy of PL/SQL Developer to use files. The source in the database is merely a result of a compilation. PL/SQL Developer does not need the source in the database at all.

It may be that I am missing some relevant details, but it seems to me that you can open the package file generated by Rational Rose in PL/SQL Developer, compile it, and subsequently use plsqldoc to generate the documentation.

We will enhance plsqldoc to work from a file though.

------------------
Marco Kalter
Allround Automations

 

[Remo Laubacher]

That's correct! I can also do this.. But I can't import the package from the file by my self. This does a tool from IFS for me (which strips the comments)..

 

[dsk@IFS]

Hi,
If you are using Design or Admin tool to Deploy the files then it removes the comments TRUE,
but you can use the PL/SQL Dev Command Window to open our *.a??' files, and Deploy it from there which does not remove the comments(--) or (/**/) Which is what I do.
Or alternatively you can even use the SqlPlus to do this
SQLPLUS ?APP/?APP@ly? @filename.a??

You are not supposed to use the and (&) sign inside a comment since SQLPLUS will ask for a value it assumes that a value is needed to continue even with in comments, But PL/SQL dev will deploy it with out any problem. But mind you we are not allowed to use (&) in comments instead use (and).
Hope This will help you out.

[This message has been edited by dsk@IFS (edited 15 July 2003).]