hi guys,
I used powerbuilder to connect MySQL database,but it
seems like that powerbuilder can not call stored
procedure in my database.
It said the database does not currently support
retrieval of procedure text.
Is this ok? or I was wrong somewhere.
Thanks.
*^_^*
Hi,
Your procedure returned correct numbers.
Does misrepresentation happens for all the runs or adhoc.
Thanks
ViSolve DB Team.
- Original Message -
From: brian stone [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 03, 2007 8:55 AM
Subject: SP not seeing INSERTs
I have an issue where inserts are not being seen properly while in a SP. The
goal is to track payments made by customers, payment distribution. I narrowed
down the issue to the below, so I was able to exclude many columns and other
tables in hopes it is simple enough to get some help.
I
I want to write a sp return paging of recordset.
CREATE PROCEDURE `sp_GetJobsDetails`(Page INT, PageSize INT)
BEGIN
DECLARE RecordBegin INT;
DECLARE tmpPageSize INT;
SET RecordBegin = Page * PageSize - PageSize;
SET tmpPageSize = PageSize + 1;
SELECT JOB_ID
Hi,
Recently, I built mysql5.0 on Solaris 10 amd64, but when running make
test, the bundled sp test failed
with the following error:
mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack
overrun: 186944 bytes used of a 262144 byte stack, and 81920 bytes
needed. Use 'mysqld
Hi Jenny
Jenny Chen wrote:
Hi,
Recently, I built mysql5.0 on Solaris 10 amd64, but when running make
test, the bundled sp test failed
with the following error:
mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack
overrun: 186944 bytes used of a 262144 byte stack
-5.0.15-nt]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 '{ call sp_GetNextInv(326,
'') }' I have double-checked, and it appears to be putting curley brackets
around the function call. I have tried this sp
How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I've got the following Stored Procedure defined in my database:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo
How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I've got the following Stored Procedure defined in my database:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo
Hi all,
I have a couple of stored procedures where SP1 is calling SP2.
SP2 has a return value which I need for SP1 to continue processing the data.
The relevant bit of SP1 looks like this:
mlCounter = 12;
call SP2(mlCounter, return_val);
Relevant bits of SP2 look like:
CREATE
another problem with the same SP. After some time (about
each 25 execution loops), i always got this error message:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
How can this be happening since I am the only who is doing anything with the
DB?
Rgds/Hardi
: Re: HELP --- Slow SP
CREATE TABLE `his_msisdn_imei_activ_hist` (
`MSISDN` varchar(23) NOT NULL,
`ACTIV_IMEI` varchar(20) NOT NULL,
`ACTIV_PHONE_TYPE` varchar(100) NOT NULL,
`PREV_IMEI` varchar(20) default NULL,
`PREV_PHONE_TYPE` varchar(100) default NULL,
`ACTIV_TIME` datetime
CREATE TABLE `his_msisdn_imei_activ_hist` (
`MSISDN` varchar(23) NOT NULL,
`ACTIV_IMEI` varchar(20) NOT NULL,
`ACTIV_PHONE_TYPE` varchar(100) NOT NULL,
`PREV_IMEI` varchar(20) default NULL,
`PREV_PHONE_TYPE` varchar(100) default NULL,
`ACTIV_TIME` datetime NOT NULL,
PRIMARY KEY
at least another 100 records per
hour.
Really appreciated if anybody can help to speed this up.
Rgds/Hardi
---
Here's the SP definition:
DELIMITER $$
DROP PROCEDURE IF EXISTS `hisdb`.`SP_HIS_NTMS_MSISDN_EDUM_REQ_PROVISIONING`
$$
CREATE
itself grows at least another 100 records per
hour.
Really appreciated if anybody can help to speed this up.
Without looking too much at the actual SP, I can tell you now that
you're not using any indexes AT ALL.
CREATE TABLE `his_msisdn_imei_activ_hist` (
`MSISDN` varchar(23) NOT NULL
[snip]
Next point is that MySQL will only make use of an index in a join or a
where clause if ONLY that field is included in the index. If you pack 3
fields into an index and then try to join on ONLY ONE field, the index
can't be used. So look at your joins and where clauses and make sure
Quentin Bennett wrote:
I think that you can use the left most columns of the index, without including
the remainder.
That's wasn't my understanding of how things work, but I've just checked
the documentation, and it looks like you're right:
docs
MySQL cannot use a partial index if the
Hi,
When I used the EXPLAIN command, i see that all of my query are using the
correct index. That's why i was quite sure that index won't be the cause of
my slow query problem.
So, i now should alter the table: remove primary key and recreate index?
Many thanks,
Hardi
On 4/28/06, Daniel
Hardi OK wrote:
Hi,
When I used the EXPLAIN command, i see that all of my query are using
the correct index. That's why i was quite sure that index won't be
the cause of my slow query problem.
So, i now should alter the table: remove primary key and recreate index?
If your queries are
Bennett; mysql@lists.mysql.com
Subject: Re: HELP --- Slow SP
Hi,
When I used the EXPLAIN command, i see that all of my query are using the
correct index. That's why i was quite sure that index won't be the cause of my
slow query problem.
So, i now should alter the table: remove primary key
-- does all the
functionality in the documentation work with MySQL? Anybody used this with
MySQL, who could describe their experience with it?
I would really love a good SP debugger!
I'm sorry to say the debugger only works with InterBase
and Firebird.
The MySQL server doesn't provide
? Anybody used this with
MySQL, who could describe their experience with it?
I would really love a good SP debugger!
I'm sorry to say the debugger only works with InterBase
and Firebird.
The MySQL server doesn't provide debugging hooks, by itself,
this is a problem for 3rd party tool vendors
Hello,
mysqldump bundled with 5.0.10 does not seem to support
the above features.
Any plans when they will be supported?
Karam
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL
mysqldump bundled with 5.0.10 does not seem to support
the above features.
http://dev.mysql.com/doc/mysql/en/mysqldump.html lists triggers in
5.0.11. I see no mention there of functions or stored procedures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello.
It seems not at the moment. See discussion at:
http://bugs.mysql.com/bug.php?id=9056
Juri Shimon [EMAIL PROTECTED] wrote:
Hello mysql,
Is mysqldump from 5.0 dumping a stored procedures?
If it isn't, then when (if planned)?
--
For technical support contracts,
Hello mysql,
Is mysqldump from 5.0 dumping a stored procedures?
If it isn't, then when (if planned)?
--
Best regards,
Juri mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
HyaFirst of all, sorry for my EnglishI have the latest version of PHP, MySQL and Apache. I tried to look for how to call a stored procedure from a PHP script.?php mysql_connect(HOST,USER,PASS); mysql_select_db(DB); $result = mysql_query( ? );...Is it works like this? Just call the SP
Is there any way to return multiple result variables from a stored
procedure? And I guess the answer is NO.
Or does anyone know how I can Concatenate (using the CONCAT function) to
glue together
my multiple results into one string that then can be post processed in
perl.
EG:
query on table
Wim Verhaert wrote:
Is there any way to return multiple result variables from a stored
procedure? And I guess the answer is NO.
Or does anyone know how I can Concatenate (using the CONCAT function) to
glue together
my multiple results into one string that then can be post processed in
perl.
I'm trying to call this simple store procedure on my XP with mysql Ver
14.3 Distrib 5.0.0-alpha, for Win95/Win98 (i32), server is
5.0.0-alpha-max-debug-log:
CREATE PROCEDURE test_repeat ()
BEGIN
SET @x = 1000;
REPEAT
SET @x = @x + 1;
UNTIL @x 10
END
:
Fax to:
07/08/2004 11:44 Subject: newbie question about sp
AM
Hi all,
Will MySql 5.0 (and higher) allow to reference the result set of a stored procedure in
the FROM clause of a query (... so as using Microsoft SqlServer, Sybase ASA, Oracle,
etc) ?
For example:
SELECT * FROM sp_test (arg1, arg2, )
We are planning to migrate to MySql . but this
adburne [EMAIL PROTECTED] wrote:
I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
mysql's page example to test but makes an error:
mysql delimeter |
You made a typo. You should write 'delimiter'.
- create function hello (s char(20)) returns
: Re: Problem creating sp
"adburne" [EMAIL PROTECTED] wrote:
I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
mysql's page example to test but makes an error:
mysql delimeter |
You made a typo. You should write 'delimiter'.
- create func
I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
mysql's page example to test but makes an error:
mysql delimeter |
- create function hello (s char(20)) returns char(50)
- return concat('Hello, ',s,'!');
ERROR 1064 (42000): You have an error in your SQL syntax
Has someone experienced a problem running MySQL v 3.23 as NT service on
Windows2000 ServicePack 3 ?
==
I'm having a problem running MySQL v 3.23 as NT service on Win2000 SP3. It
works allright in manual mode (by 'mysqld' command),
So, is there any support for stored procedures in MySQL or not
I don't think so, what do you think ?
thank you
37 matches
Mail list logo