Hi,
On Wed, Aug 15, 2012 at 1:02 AM, Little, Douglas
wrote:
> Can someone let me know the correct way to do this?
>
> This is failing
>where p.oid = cast(proname as regproc);
>
> NOTICE: found dba_work.pg_get_functiondef2
> WARNING: sqlstate 42846
> WARNING: sqlerrm cannot cast type text t
I got my function dump function to work. Enhancing to handle errors if the
object doesn't exist.
I want to add an exception block, to trap the object not found error.
But when I changed the input parameter type from regproc to text, I was no
longer getting matches.
I am trying to explicitly c
