You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Oracle functions/procedures

3 replies [Last post]
Guest's picture
Guest

Looking for a way to dump for any Peoplesoft project , sql statements from Application engines. There is a function an individual created in Sql server to do this. Does anyone have a function where you can do this in Oracle.

CompShack's picture
User offline. Last seen 6 years 3 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Oracle functions/procedures

I'm confused on what you really want. Do you want to extract SQL statements used in application engines? OR Do you want to extract SQL statements from application engines that are within application designer projects?

There is a function an individual created in Sql server to do this.

Do you think you can post it here, may be we can re-write it to work on Oracle.

Thanks.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: Oracle functions/procedures

I am just wondering , what people Tools Table stores the AE SQLs?

CompShack's picture
User offline. Last seen 6 years 3 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Oracle functions/procedures

Easy enough, here is what you need. SQL type of "1" means Application Engine SQLs.

 SELECT *
  FROM pssqltextdefn
 WHERE sqltype = 1;

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog