Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> stored procedure and a list of values

stored procedure and a list of values

From: mr_oatmeal <mr_oatmeal_at_hotmail.com>
Date: Tue, 31 Oct 2000 02:30:17 -0000
Message-ID: <svsblp5cr8qi69@corp.supernews.com>

Hi All,

I'm trying to pass a list of values into a stored procedure. I used to have this code as embeded sql and it would work, but am trying to make it a stored procedure. I pass this comma delimited list for my where clause to reference it but it does not reference it. Can I not do this or am I just doing it wrong?

Here's my declaration area: excluded_ids_in is my list ex values for excluded_ids_in: 4035,4002,4004,4025,4039

  CREATE OR REPLACE PROCEDURE sp_homepage_sectors (   sectors_cursor IN OUT cv_types.genCurType,   sector_code_in IN number,
  excluded_ids_in IN varchar,
  outer out varchar2)  

AND the select stmnt:

SELECT e.entity_code
FROM table1 e,

       table2 ae
WHERE e.entity_code = ae.entity_code
AND e.version_index = ae.version_index AND ae.sector_code = sector_code_in
AND e.entity_code not in ('excluded_ids_in')

I'm using Vignette's StoryServer (CRM software) and Oracle 8i. Storyserver Requires a certain format for calling stored procedures...

If you need any more info please let me know...

Thanks,
mr_oatmeal

--
Posted via CNET Help.com
http://www.help.com/
Received on Mon Oct 30 2000 - 20:30:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US