Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE

Have Programming Question? Ask it here!
 
 
 


rudranarayana samal
SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE
1 Answer(s)      3 years and 8 months ago
Posted in : SQL


I AM TRYING A SP BUT IT IS NOT SAVING AND WORKING.DOES THE STORED PROCEDURE WORK PARTLY? BELOW IS MY QUERY

DELIMITER$$

DROP PROCEDURE IF EXISTS `test_query`.`updt_cls_cat_name`$$

CREATE PROCEDURE `test_query`.`updt_cls_cat_name`()

    BEGIN
    DELETE FROM FEE_CLASS_CATEGORY_NAME;
    ALTER TABLE FEE_CLASS_CATEGORY_NAME AUTO_INCREMENT=20;
    INSERT INTO FEE_CLASS_CATEGORY_NAME(CLASS_CATEGORY_ID) SELECT CLASS_CATEGORY_ID FROM FEE_CLASS_CATEGORY;
    UPDATE FEE_CLASS_CATEGORY_NAME
SET CLASS_CATEGORY_NAME= CASE
    WHEN CLASS_CATEGORY_ID=1
THEN 'LOWER'
    WHEN CLASS_CATEGORY_ID=2
THEN 'MEDIUM'
    WHEN CLASS_CATEGORY_ID=3
THEN 'HIGH'
END;
    END$$

DELIMITER;

ALL THESE QUERIES OUTSIDE THE STORED PROCEDURE'S BODY ARE WORKING PROPERLY. BUT WHEN I AM TRYING TO EXECUTE THEM INSIDE IT. IT IS SHOWING ERRORS. I TRIED REMOVING THE DELIMITER KEYWORD, BUT IT IS STILL THE SAME. I AM ALSO PUTTING THE GENERATED ERROR.

(0 row(s)affected)
(0 ms taken)

(0 row(s)affected)
(0 ms taken)

Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1 (0 ms taken)


Advertisement
View Answers

November 27, 2010 at 2:48 PM


got the solution.



Related Tutorials/Questions & Answers:
SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE
SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE  I AM TRYING A SP BUT IT IS NOT SAVING AND WORKING.DOES THE STORED PROCEDURE WORK PARTLY...)affected) (0 ms taken) Error Code : 1064 You have an error in your SQL syntax
different output trying to execute same java code
there is different output trying to execute same java code...different output trying to execute same java code  i am using net...(); JOptionPane.showMessageDialog(null, "portList :"+portList.hasMoreElements()); while
Advertisements
different output trying to execute same java code
different output trying to execute same java code  i am using net...);} break; } } } When i execute from netbeans, JOptionPane showing "portList : true... " portList : false" Why there is different output trying to execute same java
different output trying to execute same java code
different output trying to execute same java code  i am using net...);} break; } } } When i execute from netbeans, JOptionPane showing "portList : true... " portList : false" Why there is different output trying to execute same java
Error in MySQL Procedure Using JAVA Code
Error in MySQL Procedure Using JAVA Code  The following Java code (using Connector/J to create a stored procedure on MySQL 5.0) does not execute...("DELIMITER //\nCREATE PROCEDURE abdt (std INT)\nBEGIN\nSELECT attbegin, attend FROM
why the program is showing error?
why the program is showing error?  <%@page import="java.sql.*"%>...; It is showing the error: An error occurred at line: 33 in the jsp file...(); while(rs.next()) { String catsid=rs.getString(3); String empid
compiled but showing below error
compiled but showing below error  Good morning, By using axis api, am getting the following error but the wsdl file is generating. what is the mistake I done. Unable to find required classes (javax.activation.DataHandler
SQLGrammarException while trying to save data in db
SQLGrammarException while trying to save data in db  //hibernate cfg file// <?xml version='1.0' encoding='UTF-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN
Showing error in the driver declaration.Please suggest
Showing error in the driver declaration.Please suggest  org.apache.jasper.JasperException: Exception in JSP: /LogIn/8June.jsp:15 12: String driver = "org.gjt.mm.mysql.Driver" 13: //String connectionURL = "jdbc:mysql
Showing Error for Prepared stmt in a jsp
Showing Error for Prepared stmt in a jsp  i hav a task to connect jsp to oracel database using preparestatement and gettin an error showin dat...;/body> </html> Error: HTTP Status 500 - type
Showing Error for Prepared stmt in a jsp
Showing Error for Prepared stmt in a jsp  i hav a task to connect jsp to oracel database using preparestatement and gettin an error showin dat...;/body> </html> Error: HTTP Status 500 - type
procedure with code - JavaMail
procedure with code  hi thank u for sending a suitable link. but in that no info about sent item folder creation. i want to place a SENT MAIL FOLDER like inbox. so all the mails that r send r srored in sent mails folder. pls
how to execute this code - JSP-Servlet
how to execute this code  hi guys can any help me in executing this bank application http://www.roseindia.net/jsp/bank.shtml, i need to use any database plz tell me step-to-step procedure for executing this,i need to create
error in program when trying to load image in java - Java Beginners
error in program when trying to load image in java  Hi, I'm trying... don't know what it means. ProductInventoryVGUI Uncaught error fetching image...) at sun.awt.image.ImageFetcher.run(Unknown Source) this is my code
Java error cannot find symbol
the variable in use its trying to refer, then it will give a error cannot find symbol...Java error cannot find symbol In this section you will learn about "cannot find symbol" in java. Java cannot find symbol is a type of error occurs
Records are not inserting in to main table while running the mysql stored procedure.
Records are not inserting in to main table while running the mysql stored procedure.  Hi, Im migrating procedures from oracle to MySql.In that procedure records are not inserted into main table from temp table.But im getting msg
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch... class therefore error occurs. Anyways, we have modified your code. import... sorab"; res=stat.executeQuery(ss); while(res.next()) { jcb.addItem
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch... class therefore error occurs. Anyways, we have modified your code. import... sorab"; res=stat.executeQuery(ss); while(res.next()) { jcb.addItem
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch... class therefore error occurs. Anyways, we have modified your code. import... sorab"; res=stat.executeQuery(ss); while(res.next()) { jcb.addItem
procedure
procedure   step by step procedure to build servlet or jsp in eclipse
error while compiling - Java Beginners
error while compiling  i am facing problem with compiling and running a simple java program, can any one help me, the error i am getting is javac is not recognised as internal or external command  Check if you JAVA_HOME
Code error
) read.close(); } } } While using this it shows error as: run...Code error  package trail; import... seconds) Hw can i correct this code????????   Basically, the Exception
procedure
procedure  write a procedure to update salary to 20% based on employee number
Error While Compiling - Java Beginners
Error While Compiling  Hi All I Am a beginner and i face the following problem while compiling can anyone help me. C:\javatutorial\example> javac HelloWorld.java 'javac' is not recognized as an internal or external
Until Loop In a Procedure
Until Loop In a Procedure       Until Loop In a Procedure is used to execute a set of statements... in a procedure. This Tutorial provides you an example to understand 'Until Loop
i got an error while compile this program manually.
i got an error while compile this program manually.  import... ActionForward execute(ActionMapping mapping...,struts jar files and i got an error in saveErrors() error Heading cannot find
java code using while loop
java code using while loop  
Do..While Loops
3.10.2. Do…While Loops The do...while statement always execute... the condition is true. Syntax do { code to be executed; } while (condition); e.g. Here we define i = 1, and then increment i with 1. The code first execute i=1+1
Error while SQL Server connection to Java
Error while SQL Server connection to Java  import java.sql.*; public class OdbcSqlServerConnection { public static void main(String args[]) throws... this code, i am getting an error as OdbcSqlServerConnection.java:29: class,interface
Error while SQL Server connection to Java
Error while SQL Server connection to Java  import java.sql.*; public class OdbcSqlServerConnection { public static void main(String args[]) throws... this code, i am getting an error as OdbcSqlServerConnection.java:29: class,interface
error while running the applet - Java Beginners
); ++num; } } } } i have problem while running the code , error...error while running the applet  import java.applet.Applet; import... 3. create a MyFrame.html file copy the following code and paste
can i Execute PHP code inside python script?
can i Execute PHP code inside python script?    can i Execute PHP code inside python script
error while running a jsp page in netbeans
error while running a jsp page in netbeans  this is error that come under column "java db processes" in netbeans Exception in thread "main" java.lang.ExceptionInInitializerError
error while inserting millions of records - EJB
error while inserting millions of records  Hello, I am using ejb cmp... problem my code is public void insertData(){ Context context... e.printStackTrace(); } }   The following error is occur
Im getting this error while running JPA project
Im getting this error while running JPA project  Exception in thread "main" javax.persistence.PersistenceException: [PersistenceUnit: examplePersistenceUnit] Unable to configure EntityManagerFactory
getting error while inserting values in database
getting error while inserting values in database  AddUser.java...) { out.println("An Error Had occurred while accessing the database..."); if (envContext == null)throw new Exception("Error: No Context
Use while loop in jsp code
Use while loop in jsp code   ... between while and do while loop, do while loop first execute the loop body...://localhost:8080/user/while_statement.jsp  Download Source Code
Error with Maven while deploying the war file
Error with Maven while deploying the war file  Hi, I am new to maven... I created java spring hibernate project.. and i kept all .java files... on the index page it shows 500 error.. My pOM.xml is 4.0.0
Error with Maven while deploying the war file
Error with Maven while deploying the war file  Hi, I am new... any link on the index page it shows 500 error.. My pOM.xml is <project...; </build> </project> But after deploying that i got this error
Error in a code. - Java Beginners
Error in a code.  This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons.... I'm confused about where and what i should put into the overall code. Also I can't
try to execute this code getting class cast exception, please resolve it.
try to execute this code getting class cast exception, please resolve it.  package test; import java.util.Arrays; import java.util.HashSet; import java.util.List; import java.util.Set; public class Over { static int k
Upload Code error on deploying
Upload Code error on deploying  on deploying the above code as it is said it is giving error that " No getter method for property thefile of bean org.apache.struts.taglib.html.BEAN " Error 500--Internal Server Error
struts code for scan the file while uploading - Struts
struts code for scan the file while uploading  Hi, I want the file to be scanned with anti-virus while uploading into server. can provide me help in this regard. Thanks in Advance.   For this you need third
Java error reached end of file while parsing
Java error reached end of file while parsing... to describe you a code that help you in understanding  java error reached end of file while parsing ,In this code we want to display Time in hour, minute
error in code - JDBC
error in code  hi friends i had one problem when i am running the application of jdbc code it is getting that Exception in thread "main" java.lang.NoSuchMethodError: main plz send me the solution for that error   
Until Loop In a Procedure
Until Loop In a Procedure       Until Loop In a Procedure is used to execute a set of statements... in a procedure. This Tutorial provides you an example to understand 'Until Loop
Error in Code - Development process
Error in Code  Hi; This is my code to get all d records from View_Service table but am getting error. I just copied this from net.I am doing mini project plz send me code to get records. What action should i mention
cannot find java.exe error while opening netbean5.5 - IDE Questions
cannot find java.exe error while opening netbean5.5  HI, 1)i am... this problem? 2)while i am installing nokiamobiletoolkit, I got the error name is windows 3 occured while loading the java vm(launching error anywhere), How can i
code error - JSP-Servlet
code error  hii this program is not working becoz when the mouse... is error in this progrm. ss function describe() { window.status... complaint   Hi friend, Do some changes in your code to solve
Snippet Code Error
Snippet Code Error  The following is a snippet of code from a Java application which uses Connector/J to query a MySQL database. Identify possible...= 0"); rs= s.getResultSet(); while (rs.next()) { Reservation v
Advertisements
 

 

 

DMCA.com