Re: Crystal Reports, passing varchar to stored procedure

From: kurt behn <kbehn_at_geonetics.com>
Date: 9 May 2003 05:33:15 -0700
Message-ID: <39675ab4.0305090433.19129f5@posting.google.com>

>
> Change your procedure parameter to IN OUT even if nothing is coming back
> out. That often solves the problem.

Thanks for the suggestion, but unfortunately, it didn't work.

>
> BTW: If your procedure is named 'cursor' rename it to something that is
> not a reserved word.

That was just a dirty example, here is the procedure declaration:

CREATE OR REPLACE procedure SP_RPT_INCOMPLETE_ELEMENTS (
io_cursor in out PKG_RPT.return_cursor, inspection_id_in in number,

 order_by		  in out varchar2,
 where_clause	  in out varchar2

)
as

All I do is open a cursor on some dynamic sequel, which works great as long as I don't pass anything into the order_by or where_clause params (and for argument's sake, the procedure works fine if i plug some other LOCAL string in the place of those clauses). Additionally the inspection_id_in works fine as it is.

Thanks again,
Kurt Received on Fri May 09 2003 - 07:33:15 CDT