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



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

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


rudranarayana samal
SHOWING ERROR CODE 1064 WHILE TRYING TO EXECUTE PROCEDURE
1 Answer(s)      4 years 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
procedure
procedure  write a procedure to update salary to 20% based on employee number
Until Loop In a Procedure
Until Loop In a Procedure       Until Loop In a Procedure is used to execute a set... in a procedure. This Tutorial provides you an example to understand 'Until
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
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
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
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  
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
Advertisements
 

 

 

DMCA.com