New to Oracle Stored Ptocedures

[rcoyle]

I am new at writing Oracle Stores procedures. I have been using MS SQL7 just fine. I can write a stores procedure in Oracle but have difficulty when writing a stored procedure that returns rows. I wand to write a stored procedure like "select * from table where col = 1" or "select lname, fname from table where col = 1" how do I create such a stored procedure in Oracle and get results using DOA components,

 

[F.Hinlopen]

Did you look at the Demos\PkgApply project? It does precisely what you want. The key procedure is SelectRecords.

------------------
Frans