Ok, so I too come from the SQL Server world, and for the past several months have been working in the Oracle world. The one thing that always amazed me is how difficult it is to return records from a stored procedure. Today I'm in the process of moving some Stored Procedures from a Package out to standalone, and I just LOVE how things that work for some parts don't work in other parts. Take for example REF CURSORS. You can't create a TYPE that is a REF CURSOR unless its in a Package (in the interest of full disclosure, this is now a "built-in" thing in 9i and above). So, now I get to go create a new standalone package with only one little line in it to hold my beloved type. FUN
Example here.
Anyhow, let this be my membership post, and also a little bit venting.
Thanks!
Damon
D
damonz
@damonz
0
Reputation
1
Posts
18
Profile views
0
Followers
0
Following
Best posts made by damonz
This user hasn't posted anything yet.
Latest posts made by damonz
-
RE: Official Membership Thread -- Just Reply Here!