Once I learned about SQL Developer, I switched from using Toad as my Query Tool. If I were to improve one thing though, it would be that the query tool understand Meta-SQL. Now, if I copy SQL from PeopleSoft, say from an Application Engine, I have to remove all of the Meta-SQL tags that PeopleTools understands before I can run it. Then, I have to replace them before copying back to PeopleTools.
I have thought about trying to write an extension for SQL Developer. Does anyone know of any documentation about writing extensions or plug-ins for SQL Developer? This might be a place to start. Another route I have thought about is an open source tool called Squirrel SQL hosted on Source Forge. It looks like it has a way to write plug-ins or extensions, but I haven’t been able to get it to connect to any of my databases yet. To be fair, I haven’t given it a thorough run-through yet.
If you have any ideas or information, please let me know.
One can also use the PeopleCode Editor to resolve Meta-SQL syntax and copying the SQL text from the Results pane instead.
digitaleagle, James says you can resolve meta-sql in the PeopleCode editor. I think James meant the SQL editor. From within the SQL editor in an AE or in an SQL defn, right-click and choose resolve Meta-SQL. Of course, this won’t resolve AE’s %Bind(), %Select(), etc, but it gets most of it right.
I have been considering a Meta-SQL project for Java as well. I think it is an outstanding idea. Just as good, I would like to see PeopleSoft expose the Meta-SQL pre-processor as some type of service. If you are a PeopleSoft customer and need this for some functionality, I would encourage you to enter it as an enhancement request in MetaLink (Customer Connection).
Jim,
This kind of fell through the cracks for me, and I just got back to it. I hadn’t been able to open requests on MetaLink or Oracle Support because I worked for Oracle partners rather than clients.
I am working for a client now, and I could request permission to open a ticket, but I don’t know that I need it for any sort of “functionality”. My biggest need is just to troubleshoot SQL from App Engines. I don’t know if it would be worth it. What do you think?