| Author |
Sybase Procedure and Driver problem
|
vijay yadav
Greenhorn
Joined: Aug 20, 2007
Posts: 8
|
|
Hi I am a salient member of this forum. I am using Sybase as database on Linux. Can any body sugget me Best JDBC driver for Sybase. And i am getting one problem while creating below procedure. i have given Procedure and Error i am getting. PROCEDURE : 1. create procedure sp_tktdetailsinsert (@tktno nvarchar(50), @priority nvarchar(10), @phno nvarchar(50), @subject nvarchar(50), @details nvarchar(50), @strdate nvarchar(50), @email nvarchar(50), @status nvarchar(50), @repliedby nvarchar(50), @file1 image, @filename varchar(50), @filesize numeric) as begin insert into ticketdetails (ticketid, priority, phonenumber, subject, details, tktdate, emailid, status, repliedby, file1, filename1, filesize1) values (@tktno, @priority, @phno, @subject, @details, @strdate, @email, @status, @repliedby, @file1, @filename, @filesize) end PROBLEM: Could not execute statement TEXT, and UNITEXT datatypes are invalid for parameters or local variables Sybse error code=2739,SQLState="ZZZZZ" Thanks, Vijay Kumar.
|
 |
 |
|
|
subject: Sybase Procedure and Driver problem
|
|
|