I'm mostly SQL Server person, so forgive me if this is too close to SQL Server, but in a nutshell using Oracle 10 I'm trying to build a procedure something like this:
PROCEDURE SP_INFO_EX_S( v_EX_ID IN NUMBER, v_EX_ROWS OUT NUMBER ) AS SELECT COUNT(*) AS ExCount FROM EXAMPLE WHERE EX_ID = v_EX_ID END SP_INFO_EX;
What I'd like this to do is return v_EX_ROWS as the total number of rows in the example table that match the WHERE Clause, but Google doesn't seem to have the answer to this. Am I missing something? Thanks!