>I need an orcale stored procedure that does this:
>
>Select * from appconfig where appconfig.app_pk = myvar into cursor MyReturnCursor
>
>...all very simple (so I thought)
>
>1. Pass parameter myvar
>2. Run select statement
>3. Get results into a cursor
>
>Anyone know the syntax to do this?
>
>Thanks!

Have you tried googling?

http://www.geekinterview.com/talk/5073-simple-example-of-oracle-stored-procedure.html