|
Home > Archive > Sybase Database > December 2005 > Internal Error: 30002 --- Sybase.Data.AseClient
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Internal Error: 30002 --- Sybase.Data.AseClient
|
|
| RobertoPerez 2005-12-06, 11:23 am |
| I few store procedures are failing and throwing "Internal Error: 30002"
error.
The store procedure is very small accepting 1 parameters and returning
always a small result set, see below.
CREATE PROCEDURE sp_rpt_web_bycase
( @i_id_case int )
AS
BEGIN
SELECT id_report, date_status,
date_standard, current_status
FROM rpt_table
WHERE id_case = @i_id_case
END
Other store procedures are receiving more parameters and executing complex
processes and works fine.
I am using Sybase.Data.AseClient
Assembly Version & File Version & Product Version
1.0.152.0
Comments
"Adaptive Server Enterprise Managed Provider"
Language
Language Neutral
Any help will be helpful.
I also saw this link
http://www.mcse.ms/_newsgroups/msgb...2Ea
donet
| |
| RobertoPerez 2005-12-06, 1:23 pm |
| In my case the problem was the "date" column. Changing the SELECT statement
as follow solved the problem:
SELECT id_report, date_status,
CONVERT( VARCHAR(19), date_standard ),
current_status
FROM rpt_table
WHERE id_case = @i_id_case
|
|
|
|
|