How do I see the signature of a stored procedure/function?
826004Feb 4 2011 — edited Feb 4 2011Someone has changed the signature of a function that I try to execute. It worked before, but now one of the parameters has changed to a new type. How can I see the content of it? This is the output in Oracle SQL Plus.
SQL> exec :rc := newcaselistforvalidation(to_date('2010-01-01','yyyy-mm-dd HH:MI:SS'),to_date('2011-01-01','yyyy-mm-dd HH:MI:SS'),100);
BEGIN :rc := newcaselistforvalidation(to_date('2010-01-01','yyyy-mm-dd HH:MI:SS'),to_date('2011-01-0
***
ERROR at line 1:
ORA-01843: not a valid month
ORA-06512: at "AST.NEWCASELISTFORVALIDATION", line 21
ORA-06512: at line 1
I suspect it's the date that has been formatted into something new.