Re: Informix stored procedure
> I need to create a stored procedure, but keep getting a syntax error.
> Error message :
> Error: A syntax error has occurred. (State:37000, Native Code: FFFFFF37)
> The code is :
> create procedure test()
I think you need a semicolon.
> DECLARE lv_tk CHAR(15),
> ln_tk_count INT
These are either two seperate variables or a ROW type.
[demime 1.01d removed an attachment of type application/pgp-signature which had a name of signature.asc]
sending to informix-list
.
Relevant Pages
- Error message in wrong language?
... If I pass in a syntax error, ... fail as expected and I get an appropriate error message in the exception. ... Since syntax errors on the same stored procedure come back in English, ... FROM ForumMessages, ForumUsers ... (microsoft.public.sqlserver.fulltext) - Re: SQL Native Client Incorrect syntax near Error
... When i run a trace i see the following syntax error on a stored ... This stored procedure is called from a VB.NET application, ... but this is a classic ADO newsgroup. ... This email account is my spam trap so I ... (microsoft.public.data.ado) - Re: Whats wrong ...man...
... >I am using stored procedure in my Visual Basic program ... > however, when I call it from program, it prompt me following error: ... > Syntax error or access violation ... (microsoft.public.sqlserver.programming) - may be .NET problem
... Hi I have a stored procedure that uses the sp_executesql to dynamically build ... query analyzer but when I try to use the ... SQL data adapter wizard I get an error (syntax error by keyword 'BY') also a ... (microsoft.public.sqlserver.server) - Re: CDO
... Regards ... I'm trying to add a stored procedure to my server ... >> But I'm getting syntax error? ... (microsoft.public.inetserver.asp.components) |
|