Ora-01747 Error In Oracle
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn java.sql.sqlexception: ora-01747: invalid user.table.column, table.column, or column specification more about Stack Overflow the company Business Learn more about hiring developers or posting
Ora-01747 Update
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community
Reserved Words In Oracle
Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-01747: invalid user.table.column, table.column, or column specification up vote 3
Ora-01747 Insert
down vote favorite Get the above error when the execute immediate is called in a loop Update CustomersPriceGroups set 1AO00=:disc Where cuno=:cuno Parameters: disc=66 cuno=000974 Update CustomersPriceGroups set 1AP00=:disc Where cuno=:cuno Parameters: disc=70.5 cuno=000974 Update CustomersPriceGroups set 1AQ00=:disc Where cuno=:cuno Parameters: disc=66 cuno=000974 Update CustomersPriceGroups set 1ZA00=:disc Where cuno=:cuno Parameters: disc=60 cuno=000974 What does this mean ? Here is the code fragment c:=PriceWorx.frcPriceListCustomers('020','221'); LOOP fetch c into comno,cuno,nama,cpls; exit 01747. 00000 - "invalid user.table.column, table.column, or column specification" when c%notfound; dbms_output.put_Line(cuno); g:=priceWorx.frcPriceListItemGroups('020','221'); d:=priceworx.frcCustomerDiscounts('020','221',cuno); loop fetch g into comno,cpgs,n; fetch d into comno,cpls,cuno,cpgs,stdt,tdat,qanp,disc,src; --dbms_output.put(chr(9)||cpgs); sQ:='Update saap.CustomersPriceGroups set "'|| trim(cpgs)||'"=:disc ' || ' Where cuno=:cuno'; execute immediate sQ using disc,cuno; commit; dbms_output.put_line( sQ ); dbms_output.put_line( chr(9)||'Parameters: disc='|| disc||' cuno='||cuno); exit when g%notfound; end loop; close g; close d; end loop; oracle plsql dynamic-sql share|improve this question edited Feb 27 '12 at 8:32 Alex Poole 86.9k55993 asked Feb 27 '12 at 2:02 TonyP 2,22073363 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote accepted Unquoted identifiers must begin with an alphabetic character (see rule 6 here). You're trying to assign a value to a column with a name starting with a number 1AO00, 1AP00 etc. Without seeing the table definition for CustomersPriceGroups we don't know if it has columns with those names. If it does then they must have been created as quoted identifiers. If so you'll have to refer to them (everywhere) with quotes, which is not ideal - makes the code a bit harder to read, makes it easy to make a mistake like this, and can be hard to spot what's wrong. Even Oracle say, on the same page: Note: Oracle does not recommend using quot
throwing ajava.sql.SQLSyntaxErrorException. This will prevent JIRA applications from starting up. The following appears in theatlassian-jira.log: 2012-11-14 09:43:10,746 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist oracle reserved words 11g Launcher 2012-11-14 09:43:14,505 main ERROR [jira.upgrade.util.UpgradeUtils] JDBC get version number failed. 01747 zip code SQL: SELECT ps.null FROM propertyentry pe, propertystring ps WHERE pe.null='jira.version.patched' AND pe.null=ps.null java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, ora-00984 table.column, or column specification Cause OFBiz, the persistence framework that JIRA applications use is querying the Oracle database with a column name of null instead of the http://stackoverflow.com/questions/9459204/ora-01747-invalid-user-table-column-table-column-or-column-specification appropriate column name (propertyvalue).This is a symptom of a non-standard configuration of the Oracle database connection that is not currently supported. For example, the JIRA application DB is created using one user with a full set of permissions and then restarted with another user that does not have the required permissions. Resolution It is critical https://confluence.atlassian.com/display/JIRAKB/How+to+Fix+Oracle+Error+ORA-01747%3A+invalid+user.table.column,+table.column,+or+column+specification to the operation of JIRA applications that these permissions are provided as we now use theActive Objectspersistence ORM in a lot of our plugins and also third-party plugins may use it. If JIRA applications do not have the appropriate permissions to create objects within the database, plugin installations and upgrades can fail, as mentioned ORA-01031KB article. Stop your JIRA applications. Ensure the JIRA application DB user has the required permissions, as in Connecting JIRA applications to Oracle. Start your JIRA applications. Was this helpful? Yes No Thanks for your feedback! Why was this unhelpful? It wasn't accurate It wasn't clear It wasn't relevant Submit feedback Cancel Have a question about this article? See questions about this article Powered by Confluence and Scroll Viewport Atlassian Support Ask the community Provide product feedback Contact technical support Atlassian Privacy Policy Terms of use Security Copyright © 2016 Atlassian Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.
discuss with dev team? Forum is the right place! On break with the proprietary solutions, Talend Open Data https://www.talendforge.org/forum/viewtopic.php?id=39796 Solutions has the most open, productive, powerful and flexible Data Management solutions or manage your data warehouse- Open Studio -to the data integration market. Talend integrates, consolidates, transforms any data - Business - Extract Transform Load - ETL - EAI - ERP Index Tags Timeline User list Rules Search You are not logged in oracle in. Topics: Active | Unanswered Announcement [2016-09-29] For Test Only, Talend Open Studio's 6.3.0 RC1 release is available [2016-09-20] Free Trial: Download the New Talend Big Data Sandbox [2016-09-15] Talend Open Studio v6.1.2 is now available for download [2016-09-14] Sign Up Now For Talend Connect 2016 in Paris [2016-09-09] Have a Talend Story Worth invalid user.table.column, table.column, Sharing? You Too Can Be on The Podium Unanswered posts Formatting tRESTResponse as object instead of array byhansena Variables from file (SSH Automation) bytibun Unable to install TOS_DI-win-x86_64 on windows 10 byvidyamj Unable to install TOS_DI-win-x86_64 on windows 10 byvidyamj Composant TOracleSCD [...] bya2d2 Index »Open Data Integration - Usage, Operation »[resolved] ORA-01747: invalid user.table.column, table.column, or column specific Pages: 1 Post reply #12014-12-02 13:38:21 soukainaez Member 53 posts soukainaez said: [resolved] ORA-01747: invalid user.table.column, table.column, or column specific hello,im trying to load data to my fact table from the different dimensions .i have create one connection to my DataBase, all the tables(dimensions and fact) are under the same connection.But when i execute the job, i have this error: java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification.Can anyone told me whats the problem please. Last edited by soukainaez (2014-12-02 13:38:59) Offline Quote #22014-12-02 13:57:37 sanvaibhav Member 1719 posts sanvaibhav said: Re: [resolved] ORA-01747: invalid user.table.column, table.column, or co