plsql - Can Oracle's SQL Translation Framework translate SQL embedded in PL/SQL? -

-

can oracle's sql translation framework translate sql queries embedded in pl/sql blocks?

i have translation profile , translation in place, if put sql in, say, sql plus, translates correctly.

but if sql inside plsql, in execute immediate ('here'), or in cursor declaration cursor mycursor select 'here'....., there no translation done.


Comments

Post a Comment

Popular posts from this blog

java - Unable to make sub reports with Jasper -

-
i using jaspersoft studio create reports. having sub report in jasper main report. problem unable make work, because if add sub report detail band of main report, sub report generated number of times, row row, entire sub report repeated in number of pages. can't put in summery band due same reason. i unable put in column footer band or other footers because displays below error net.sf.jasperreports.engine.jrexception: net.sf.jasperreports.engine.jrruntimeexception: subreport overflowed on band not support overflow. @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.fillreport(reportcontroler.java:467) @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.access$18(reportcontroler.java:442) @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler$4.run(reportcontroler.java:334) @ org.eclipse.core.internal.jobs.worker.run(worker.java:54) caused by: net.sf.jasperreports.engine.jrruntimeexception: subreport overflowe...
Read more

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

-
i getting error message , further 1 here: failed read artifact descriptor org.apache.maven.plugins:maven-install-plugin:jar:2.4: even though when go .m2 repository path c:\users\a591024.m2\repository\org\apache\maven\plugins\maven-resources-plugin\2.4 the maven-resources-plugin-2.4.jar file there , maven-resources-plugin-2.4.pom there. have tried delete .m2 repository no luck. far maven not build project desperately need to. any ideas? it seems proxy issue please aad following in setting.xml grabbing lan setting , proxy information. <proxies> <proxy> <id>proxy</id> <active>true</active> <protocol>http</protocol> <host>hostname</host> <port>port</port> </proxy> </proxies> this frequent issue, please see below link well. plugin org.apache.maven.plugins:maven-clean-plugin:2.5 or 1 of dependencies not resolved maven: failed ret...
Read more

Save and close a word document by giving a name in R -

-
i trying use 2 libraries ( descstool , r2wd ) in order descriptive analysis of dataset saved in folder exploration later. these steps trying library(desctools) library(r2wd) data(iris) <- ls() wrd <- getnewwrd(header=true) wdget() desc(get(i), plotit=true, wrd=wrd) wdsave(name="temp.doc", wdapp=.r2wd) wdquit() although word capturing output supposed be, cannot save word file giving name (e.g.: temp.doc). can shed light here? try library(desctools) wrd <- getnewwrd() desc(iris, wrd=wrd) wrd[["activedocument"]]$saveas2(filename="describe iris.docx") wrd$quit()
Read more