search

neil-bowers / oracle-ddl2svn

Automatically exported from code.google.com/p/oracle-ddl2svn
0 stars 0 forks source link

invoking DBMS_METADATA.SET_TRANSFORM_PARAM fails on oracle 10g #20

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. build from
Revision: 146
Author: wallyatkins
Message:
Updated transform params a little. It looks like there should not be an auto 
commit on these calls and Oracle 11g uses TRUE and FALSE instead of 1 and 0.
----
Modified : /trunk/scheme2ddl/src/ru/qwazer/scheme2ddl/Dao.java

2. run againist oracle 10g
3. got error

Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: 
ConnectionCallback; bad SQL grammar []; nested exception is 
java.sql.SQLException: ORA-06553: PLS-221: 'SESSION_TRANSFORM' is not a 
procedure or is undefined

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)
    at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Dao.java:59)
    at ru.qwazer.scheme2ddl.Dao.fillDDL(Dao.java:46)
    at ru.qwazer.scheme2ddl.Worker.work(Worker.java:39)
    at ru.qwazer.scheme2ddl.Main.main(Main.java:59)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)
Caused by: java.sql.SQLException: ORA-06553: PLS-221: 'SESSION_TRANSFORM' is 
not a procedure or is undefined

Original issue reported on code.google.com by resh...@gmail.com on 9 Jun 2011 at 5:53

GoogleCodeExporter commented 9 years ago 
 For variables and constants in the package can only be accessed from the PL / SQL, not from SQL as in my case. So i replace sys.DBMS_METADATA.SESSION_TRANSFORM in value -1 (for oracle 10 it works)

Original comment by resh...@gmail.com on 9 Jun 2011 at 6:12

GoogleCodeExporter commented 9 years ago 
Revision: 147
Author: resheto@gmail.com
Date: 10:16:10, 9 июня 2011 г.

----
Modified : /trunk/scheme2ddl/src/ru/qwazer/scheme2ddl/Dao.java

Original comment by resh...@gmail.com on 9 Jun 2011 at 6:17