Stored Procedures
Daniel Isven got error -201 creating a simple stored procedure with RETURNING INTEGER. Thomas Parsli suggested CREATE FUNCTION, which failed the same way; Christian Brauer thought functions were only for the Universal Server, not IDS. David Williams said CREATE PROCEDURE only works in dbaccess, not isql. No confirmed fix was reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi
I get the most stupid errors when I try to create a stored procedures.
But probabli I'm the one that's stupid. I have never done this before so
I don't really know what to do and I can't seem to find anything about
it in any manual either. Can anyone help me with this.
I'm trying to create the procedure below and i get error -201, syntax
error.
CREATE PROCEDURE proc_name
RETURNING INTEGER; RETURN 7;
END PROCEDURE
Thanx, Daniel
Daniel Isv'n <daniel.isven@tubenteknik.se> writes:
> Hi
>
> I get the most stupid errors when I try to create a stored procedures.
> But probabli I'm the one that's stupid. I have never done this before so
> I don't really know what to do and I can't seem to find anything about
> it in any manual either. Can anyone help me with this.
> I'm trying to create the procedure below and i get error -201, syntax
> error.
>
> CREATE PROCEDURE proc_name
> RETURNING INTEGER;> RETURN 7;
> END PROCEDURE
RTFM;)
CREATE FUNCTION proc_name ()
RETURNING INTEGER; RETURN 7;
END FUNCTION;
Thomas
I can create the procedure when i write CREATE PROCEDURE proc_name() but if i
replace PROCEDURE with FUNCTION i get the same error again...
Daniel
Thomas Parsli wrote:
> Daniel Isvén <daniel.isven@tubenteknik.se> writes:
>
> > Hi
> >
> > I get the most stupid errors when I try to create a stored procedures.
> > But probabli I'm the one that's stupid. I have never done this before so
> > I don't really know what to do and I can't seem to find anything about
> > it in any manual either. Can anyone help me with this.
> > I'm trying to create the procedure below and i get error -201, syntax
> > error.
> >
> > CREATE PROCEDURE proc_name
> > RETURNING INTEGER;> > RETURN 7;
> > END PROCEDURE
>
> RTFM;)
>
> CREATE FUNCTION proc_name ()
> RETURNING INTEGER;> RETURN 7;
> END FUNCTION;
>
> Thomas
Daniel Isvén schrieb: > > I can create the procedure when i write CREATE PROCEDURE proc_name() but if i > replace PROCEDURE with FUNCTION i get the same error again... > I think you can use "create function" only using UDO, not IDS... Hth, Chris
In article <900o2n22.fsf@localhost.localdomain>, Thomas Parsli
<thomas.parsli@startsiden.no> writes
>Daniel Isvén <daniel.isven@tubenteknik.se> writes:
>
>> Hi
>>
>> I get the most stupid errors when I try to create a stored procedures.
>> But probabli I'm the one that's stupid. I have never done this before so
>> I don't really know what to do and I can't seem to find anything about
>> it in any manual either. Can anyone help me with this.
>> I'm trying to create the procedure below and i get error -201, syntax
>> error.
>>
>> CREATE PROCEDURE proc_name
>> RETURNING INTEGER;>> RETURN 7;
>> END PROCEDURE
>
Create procedure only works in dbaccess, NOT isql!
>RTFM;)
>
>CREATE FUNCTION proc_name ()
> RETURNING INTEGER;> RETURN 7;
>END FUNCTION;
>
>Thomas
--
David Williams