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)