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:
Sent: Wednesday, January 03, 2007 8:55 AM
Subject: SP not seeing INSERTs w
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 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: Thr
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
ht 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 in straight MySQL command,
and it works fine, it's just calling it from ASP and ASP.net that seems
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 Va
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 PROCEDURE
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 V
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
bject: 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` v
> > 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,
> >
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 prima
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 us
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 Kasak
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:
MySQL cannot use a partial index if the colum
[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
your
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
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`
$$
C
gt;
>>
>> I'd like to hear more about the stored procedure debugger -- 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 debu
t;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 debu
> 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 uns
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 Gen
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 cont
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:http://lists.mysql
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. mysql_connect(HOST,USER,PASS); mysql_select_db(DB); $result = mysql_query( ? );...Is it works like this? Just call the SP
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.
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
ne.com> cc:
Fax to:
07/08/2004 11:44 Subject: newbie question about sp
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
EN
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
ECTED]
Asunto: 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 |
"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 'deli
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
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), bu
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
