Hi, I already got this one. thanks for your help!!!
:D:)...
User Profile
Collapse
-
i'm using sqlyog. so i call it in the query tab.
what i did is this:
call sp_name('select * from person');...Leave a comment:
-
I've tried it out already but it doesn't work.:(
It says:
Error Code : 1243
Unknown prepared statement handler (q) given to EXECUTE
what does this mean?
thanks for your help!...Leave a comment:
-
Ah..what i want to do is create a stored procedure that will execute any query that i like to pass. the query would vary depending on the java class. the java class would then pass it to the mysql....Leave a comment:
-
Problem in select stmt inside stored procedure
Hello, i've a problem regarding the select stmt inside the stored procedure.
Here's my code:
[code=sql]
DELIMITER $$
DROP PROCEDURE IF EXISTS `p`.`getNames`$ $
CREATE PROCEDURE `p`.`getNames`( q varchar)
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
...
No activity results to display
Show More
Leave a comment: