Board index » delphi » Array var in PLSQL ?
Mike
Delphi Developer |
Mike
Delphi Developer |
Array var in PLSQL ?2005-06-13 04:48:18 PM delphi236 How can I create a array variable in PLSQL ? It should looks something like this... but this doesn't works :-( : CREATE PROCEDURE PLANNING_TEMPS_PROD ( YEAR INTEGER) RETURNS ( MY_RETURN INTEGER) AS DECLARE VARIABLE ARRAY_N INTEGER[1:31]; // I need 31 positions in the array BEGIN END Thanks for any ideas Mike |
Paul
Delphi Developer |
2005-06-13 05:23:10 PM
Re:Array var in PLSQL ?
"Mike" <XXXX@XXXXX.COM>writes:
Ca devrait etre Ask, et pas Aks! 8-) QuoteHow can I create a array variable in PLSQL ? de tableaux. Je le déconseille fortement, cependant. Arrays are poorly supported by Interbase, *_and_* they breach the relational model *_and_* they make porting any application a cauchemar. Paul... -- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 9.2.0.1.0 (Enterprise Ed.) Interbase 6.0.1.0=6; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, As a courtesy to those who spend time analysing and attempting to help, please do not top post. |
Mike
Delphi Developer |
2005-06-13 07:58:03 PM
Re:Array var in PLSQL ?Quote"Mike" <XXXX@XXXXX.COM>writes: Quote>How can I create a array variable in PLSQL ? You're speaking frenglish very well :-) @+ Mike |