Click here to Skip to main content
15,353,970 members
Home / Discussions / Database
   

Database

 
QuestionNeed a Select query that filter illegal characters Pin
nainakarri21-Jan-15 19:14
Membernainakarri21-Jan-15 19:14 
AnswerRe: Need a Select query that filter illegal characters Pin
Eddy Vluggen22-Jan-15 0:28
professionalEddy Vluggen22-Jan-15 0:28 
AnswerRe: Need a Select query that filter illegal characters Pin
Umer Akram29-Jan-15 18:58
MemberUmer Akram29-Jan-15 18:58 
QuestionLet sql server code works for all SQLServer versions Pin
MrKBA19-Jan-15 23:10
MemberMrKBA19-Jan-15 23:10 
AnswerRe: Let sql server code works for all SQLServer versions Pin
Eddy Vluggen22-Jan-15 0:26
professionalEddy Vluggen22-Jan-15 0:26 
Questionchanging the field of database based on changes in repeater Pin
Armi.R16-Jan-15 21:21
MemberArmi.R16-Jan-15 21:21 
AnswerRe: changing the field of database based on changes in repeater Pin
Mycroft Holmes19-Jan-15 23:57
professionalMycroft Holmes19-Jan-15 23:57 
QuestionDB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 2:59
Membersudevsu16-Jan-15 2:59 
I have a store procedure in my DB2 Database. It is just a simple insert statement. I have 10 columns in the table and each value is passed as a parameter to Store procedure and when I execute it throws an error

Overload resolution failed because no accessible 'Parameters' accepts this number of arguments.

My Store procedure is
CREATE PROCEDURE DEVSUSH.SP_CUSTINFO ( 
	IN PRMCICID INTEGER , 
	IN PRMCIFN VARCHAR(30) , 
	IN PRMCILN VARCHAR(30) , 
	IN PRMCIADDR VARCHAR(90) , 
	IN PRMCICITY VARCHAR(20) , 
	IN PRMCISTATE VARCHAR(20) , 
	IN PRMCIZIP NUMERIC(9, 0) , 
	IN PRMCIPHONE NUMERIC(10, 0) , 
	IN PRMCIEMAIL VARCHAR(30) , 
	IN PRMCICLDATE DATE ) 
	LANGUAGE SQL 
	SPECIFIC DEVSUSH.SP_CUSTINFO 
	NOT DETERMINISTIC 
	MODIFIES SQL DATA 
	CALLED ON NULL INPUT 
	SET OPTION  ALWBLK = *ALLREAD , 
	ALWCPYDTA = *OPTIMIZE , 
	COMMIT = *NONE , 
	DECRESULT = (31, 31, 00) , 
	DFTRDBCOL = *NONE , 
	DYNDFTCOL = *NO , 
	DYNUSRPRF = *USER , 
	SRTSEQ = *HEX   
	P1 : BEGIN 
INSERT INTO DEVSUSH . CLCUSINF ( CICID , CIFN , CILN , CIADDR , CICITY , CISTATE , CIZIP , CIPHONE , CIEMAIL , CICLDATE ) VALUES ( @PRMCICID , @PRMCIFN , @PRMCILN , @PRMCIADDR , @PRMCICITY , @PRMCISTATE , @PRMCIZIP , @PRMCIPHONE , @PRMCIEMAIL , @PRMCICLDATE ) ; 
END P1  ; 
  

GRANT ALTER , EXECUTE   
ON SPECIFIC PROCEDURE DEVSUSH.SP_CUSTINFO 
TO SUSHDEV ; 
  
GRANT EXECUTE   
ON SPECIFIC PROCEDURE DEVSUSH.SP_CUSTINFO 
TO VAIGROUP ;


How to solve the error?
Your help is much appreciated.
Thanks
Happy Coding!

QuestionRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:10
professionalGuyThiebaut16-Jan-15 3:10 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:22
Membersudevsu16-Jan-15 3:22 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:46
professionalGuyThiebaut16-Jan-15 3:46 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:55
Membersudevsu16-Jan-15 3:55 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:21
Membersudevsu16-Jan-15 3:21 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:59
professionalGuyThiebaut16-Jan-15 3:59 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:30
Membersudevsu16-Jan-15 4:30 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:41
professionalGuyThiebaut16-Jan-15 4:41 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:43
Membersudevsu16-Jan-15 4:43 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:48
professionalGuyThiebaut16-Jan-15 4:48 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:50
Membersudevsu16-Jan-15 4:50 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 5:05
professionalGuyThiebaut16-Jan-15 5:05 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 5:09
Membersudevsu16-Jan-15 5:09 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 5:10
professionalGuyThiebaut16-Jan-15 5:10 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 5:17
Membersudevsu16-Jan-15 5:17 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 5:19
professionalGuyThiebaut16-Jan-15 5:19 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 5:23
Membersudevsu16-Jan-15 5:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.