DB2

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesDB2

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old April 22nd, 2012, 06:45 AM
shamsheralam shamsheralam is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Apr 2012
Posts: 1 shamsheralam User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 m 30 sec
Reputation Power: 0
Error while executing stored procedure??? Please help me out.

Hi All,

I am trying to execute the below stored procedure, but its giving error ,can anyone suggest me whts wrong in thsi procedure.


A database manager error occurred.SQLCODE: -811, SQLSTATE: 21000 - The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row.. SQLCODE=-811, SQLSTATE=21000, DRIVER=3.62.80



CREATE PROCEDURE SWB.UPDATE_SWBUSER
(INOUT USERNAME VARCHAR(128),
INOUT EMAIL VARCHAR(128),
INOUT NOTESID VARCHAR(128),
INOUT ROLENAME VARCHAR(64))
MODIFIES SQL DATA
LANGUAGE SQL

P1: BEGIN

DECLARE R_KEY INTEGER;
DECLARE U_KEY INTEGER;

INSERT INTO SWB.SWBUSERS(USERNAME,EMAIL,NOTESID)values (USERNAME,EMAIL,NOTESID);
commit;

SET R_KEY=(SELECT distinct ROLE_KEY FROM SWB.ROLE_MASTER WHERE ROLE_NAME =ROLENAME);
SET U_KEY=(SELECT distinct USER_KEY FROM SWB.SWBUSERS WHERE EMAIL=EMAIL);

INSERT INTO SWB.ROLE_USER_BRIDGE (ROLE_KEY,USER_KEY)VALUES(R_KEY,U_KEY);
commit;

END P1
;

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesDB2 > Error while executing stored procedure??? Please help me out.


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap