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.