bonjour,
Le jeudi 20 mai 2004, Norbert Felde a �crit...
> CREATE DBPROC CEG_KH_LIST (
> IN CID Integer,
> IN ORD Varchar(30),
> IN SORT Integer,
> IN SROW Integer,
> IN EROW Integer
> )
> RETURNS CURSOR AS
> $CURSOR = 'LIST_RES';
> DECLARE :$CURSOR CURSOR FOR
> SELECT * FROM (
> SELECT ROWNO AS RN,*
> FROM DBA.table1 AS A, DBA.table2 AS B
> WHERE A.CID = :CID AND A.ID = B.AID(+)
> ORDER BY :ORD )
> WHERE RN >= :SROW AND RN < :EROW;
Because of ORD, which is a column name, I think you need dynamic sql:
stmt = 'DECLARE ' || $CURSOR || ' CURSOR FOR SELECT.....ORDER BY ' || \
ORD;
execute (stmt);
and you won't call the parameter with :parameter, but with parameter.
But I'm not sure this is related to your problem...
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
