arissonleal Posted April 9, 2009 Share Posted April 9, 2009 How can i set the schema for my tELTOracleOutput ?I always got this error: Exception in component tELTOracleOutput_1java.sql.SQLException: ORA-00942: table or view does not exist In my tELTOracleInput componets i've put the schema for my tables and work fine, but if i put for the tELTOracleOutput i got this new error:Exception in thread "main" java.lang.Error: Unresolved compilation problem: MYSchema cannot be resolved at my_local.test.test.tELTOracleMap_1Process(ncapp_sep.java:167)at my_local.test.test.runJobInTOS(ncapp_sep.java:361) at my_local.test.test.main(ncapp_sep.java:278) How can i solve this problem ?? Link to comment Share on other sites More sharing options...
pannila Posted June 2, 2009 Share Posted June 2, 2009 Have you set "Action on table" to "Create if not exists" or "Create table"?This should fix your problem.BR Kari Link to comment Share on other sites More sharing options...
rodriguezum Posted July 8, 2009 Share Posted July 8, 2009 i don't see that option in teltoracleoutput, what i use is just tcreatetable befor the toraclemap Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now