PL/SQL (MOSC)

MOSC Banner

Issue on function in plsql

edited Oct 28, 2015 10:06AM in PL/SQL (MOSC) 11 commentsAnswered

I have the below function I am trying to write but when I execute plsql with debugger it says the below error

at line

Begin

         SELECT TO_CHAR(ordered_date,'MON')

          into odate

          FROM oe_order_headers_all

          where header_id =p_header_id

execution has terminated at line

'  Begin

      if avg_ord_qty > fmon then  ....'

Could anyone help to solve the issue

I need to compare the average sales of the last 3 month with the forecast.  Which ever highest shld be compared with (onhand qty+pending qty-requested qty of actual order) COMAPRED QTY

If average sales or forecast < Compared qty it should return 1 else it return 0

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center