I have a stored Proc that returns a REF CUROSR (Pointer).
In VB using ADO 2.5 I can happily assign this to a recordset and look thru what I have.
How though can I do this Server side in PL/SQL.
It sounds like it should be very easy.
One answer is to use a a parameterized cursor rather than a stored proc but I wish to avoid this if possible.
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.