variables stored procedure

[Danny Lewkin]

Done!

http://valentina-db.com/bt/view.php?id=2703



Op 3-okt-07, om 16:02 heeft Ivan Smahin het volgende geschreven:

> Hello Danny,
>
> Wednesday, October 3, 2007, 10:40:07 AM, you wrote:
>
>> Hi List,
>
>> I'm trying to create this stored procedure:
>
>> create or replace procedure ct_select_competences_module(in
>> intModuleID long, IN intOrganisationID LONG, IN strSelectList  
>> VARCHAR)
>> Begin
>>         CASE strSelectList
>>         WHEN 'Module' THEN
>>                 SElect RecID, objptr_module, objptr_comppool->name  
>> As competence_name,
>>                 objptr_comppool->description As comp_description FROM
>> tbl_comppool_modules
>>                 WHERE objptr_module = intModuleID;
>>         WHEN 'All' THEN
>>                 SELECT RecID, name, description FROM  
>> tbl_competence_pool
>>                 WHERE RecID NOT IN (SELECT objptr_comppool FROM
>> tbl_comppool_modules WHERE objptr_module = intModuleID) AND
>> objptr_organisation = intOrganisationID;
>>         END CASE
>> END
>
>> but, I get an error (of course   :
>
>> 09:31:19: Error: Kernel error: 0x51500. Identifier "intModuleID" is
>> not found.
>
>> Seems that the second time I use 'intModuleID' (in the sub-select),
>> it doesn't recognize that variable anymore... If I ONLY replace
>> intModuleID in the SUBSELECT BY 1 (or something like that), the
>> stored procedure is created...
>
>
>> What am I doing wrong?
>
> Obviously, it is a bug. Report it to mantis please.
>
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina