wood burning stoves 2.0*
The moose likes JDBC and the fly likes Sybase Procedure and Driver problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Sybase Procedure and Driver problem" Watch "Sybase Procedure and Driver problem" New topic
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sybase Procedure and Driver problem