Oracle Error Ora-01740
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 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community 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 Error with the query in Oracle up vote 2 down vote favorite I am using Oracle and using in my toad to check what the result is. But I am getting error as ORA-01740: missing double quote in identifier Here is my query SELECT T1.Project_Id, PROPERTY_NAME Project_name, T1.Vehicle_No, T1.Creation_date, T1.Time_In, T1.Time_Out FROM XXCUS.XX_SUPINV T1 INNER JOIN XXACL_PN_PROJBUILD_V T2 ON T1.Project_Id = T2.Project_id WHERE t1.Project_Id = '" + ddlProjectName.SelectedValue + "' AND Creation_date BETWEEN to_date fnd_conc_date.string_to_date('"TxtIndate.Text"') AND to_date fnd_conc_date.string_to_date('"txtOutDate.Text"')" Please suggest where I am mistaking sql asp.net oracle oracle10g share|improve this question edited Jul 4 '15 at 7:54 Maheswaran Ravisankar 12.6k41752 asked Jul 4 '15 at 7:26 nad 2,08531235 is this your final constructed query? to_date() has to be like to_date('20-Jan-2015','DD-Mon-YYYY') .. your date conversion here is bit confusing –Maheswaran Ravisankar Jul 4 '15 at 7:57 @MaheswaranRavisankar: Yes, I tried in my Toad but giving error –nad Jul 4 '15 at 7:57 @MaheswaranRavisankar: OK let me edit and check –nad Jul 4 '15 at 8:02 There seems to be an unmatched " at the very end of your statement... (to start with...) –Abecee Jul 4 '15 at 8:05 @Abecee: can you please help me with the correct query. –nad Jul 4 '15 at 8:15 | show 5 more comments 3 Answers 3 active oldest votes up vote 1 down vote accepted This is the actual Query (with data) you're trying to execute. SELECT T1.Project_Id, PROPERTY_NAME Project_name, T1.Vehicle_No, T1.Creation_date, T1.Time_In, T1.Time_Out FROM XXCUS.XX_SUPINV T1 INNER JOIN XXACL_PN_PROJBUILD_V T2 ON T1.Project_Id = T2.Project_id WHERE t1.Project_Id = '409' AND Creation_date BETWEEN to_date('01-jan-2015','DD-mon-yyyy') AND to_date('01-jan-2012','DD-mon-yyyy') You're programmatic version could be ( Just derived from your base version) sl = "SELECT T1.Project_Id, PROPERTY_NAME Project_name, T1.Vehicle_No, T1.Creation_date, T1.Time_In, T1.Time_Out FROM XXCU
or _, it must be enclosed in double quotes.ActionAdd a closing double quote (") http://stackoverflow.com/questions/31218137/error-with-the-query-in-oracle to the end of the identifier. Add Comment Your Comment Name: Comment: Captcha: Post Comment More Information The Google Search results shown above are http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-01740 obtained by searching for this error using a custom google search engine which is restricted to a specific list of oracle reference sites. If you know a good oracle reference/help site and think that site should be included in this search, you can contribute to this search engine here. Get super fast VPS hosting from just $5/mo! Hits: 14672938 Books Terms & Conditions About Comments Facebook Sitemap Copyright © 2013
TABLESPACE, there was a failure in getting the date and time. Action: Contact Oracle Support Services. ORA-01501 CREATE DATABASE failed Cause: An error occurred during CREATE DATABASE. Action: See accompanying errors. ORA-01502 index 'string.string' or partition of http://docs.oracle.com/cd/B10501_01/server.920/a96525/e1500.htm such index is in unusable state Cause: An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation. Action: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition. ORA-01503 CREATE CONTROLFILE failed Cause: An error occurred during CREATE CONTROLFILE. Action: See accompanying errors. ORA-01504 database name 'string' does not match parameter oracle error db_name 'string' Cause: The name in a database create or mount does not match the name given in the initialization parameter DB_NAME. Action: Correct or omit one of the two names. ORA-01505 error in adding log files Cause: During CREATE or ALTER DATABASE, error(s) occurred when adding new log files. Action: Check error stack for detailed error information. ORA-01506 missing or illegal database name Cause: No database name was specified in oracle error ora-01740 the CREATE/ALTER DATABASE statement, and no DB_NAME initialization parameter was specified. Action: Either the database name must be given in the statement or in the DB_NAME initialization parameter. Note that the SVRMGR or SQL*PLUS STARTUP command issues an ALTER DATABASE statement using the database name specified as part of STARTUP (if any). ORA-01507 database not mounted Cause: A command was attempted that requires the database to be mounted. Action: If you are using the ALTER DATABASE statement via the SVRMGR or SQL*PLUS STARTUP command, specify the MOUNT option to restart; else if you are directly doing an ALTER DATABASE DISMOUNT, do nothing; else specify the MOUNT option to ALTER DATABASE. If you are doing a backup or copy, you must first mount the desired database. ORA-01508 cannot create database; error in file 'string' at line string Cause: CREATE DATABASE was unable to process the specified file. Action: Check the offending line in the specified file. ORA-01509 specified name 'string' does not match actual 'string' Cause: The database name specified in ALTER DATABASE does not match the name of the currently mounted database. Action: Correct the database name spelling or DISMOUNT the mounted database. ORA-01510 error in deleting log files Cause: During ALTER DATABASE, an error occurred while dropping log files. Action: Check t