Oracle Reports (MOSC)

MOSC Banner

Error in Oracle Reports 12c Lexical Parameters

I have created a report with the following code in Oracle Reports 12c. I am using Oracle Database 19c:

SELECT &c act_date,&c1 act_amnt FROM &tble &s

In After Parameter Form, I have substituted each lexical parameter with actual table column names, table names and where clause. I reproduce a sample of the code here.

function AfterPForm return boolean is

begin


:c := 'act_date';

 :c1 := '-1*SUM(NVL(act_amnt,0.00))/10000000';

 :tble := 'ACNTNG_TRNSCTN';

  

 IF :P_TYPE = 'LOC' THEN

  :s := 'WHERE act_acnt_code IN (''E01022'',''E01023'') AND act_date BETWEEN :P_FROM_DT AND :P_TO_DT AND ACT_NRTN NOT IN( ''A08009'') group by act_date';

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