Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calll to a Procedure via Decode function

nirSep 12 2011 — edited Sep 12 2011
Hi,

I just want to know whether it is possible to call to precudure like below,

select inv.invoice_id, decode('AS_AP_INV_APPROVESTATUS(inv.invoice_id)','N',+
decode(AMOUNT_PAID,null,'Enterd',0,'Entered')) stat
from apps.AP_INVOICES_ALL inv

This returns only (null) value.

Is any syntax error or is there any other way to invoke this?

Thank you,
This post has been answered by Kim Berg Hansen on Sep 12 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2011
Added on Sep 12 2011
#plsql
3 comments
828 views